Calculated Date Field - 7 days later

[MrsTFB]

Hey,
I have not posted in some time, but I assume it works the same. I have a date field, that I would like to be able to calculate one week later. I'm using Excel 2000 and have say 5/14/03 in E6, in E12, I want the date to be 5/21/03. I know there is probably a formula for that, but I could not find it anywhere. Also, if e6 changes, e12 should change accordingly.
Thanks for any help!
Mrstfb in Tennessee!

 

[SuicidED]

Hi in E12 =E6+7

 

[mbarron]

Your formula in e 12 would be

=E6 + 7

Mike

 

[Bowers74]

MrsTFB,

May I point you towards the following FAQ:

faq68-4037 - What are some of Excel's date functions?

It might come in handy for you in the future! ;-)



Peace!!

Mike

Didn't get the answers that you wanted? Take a look at FAQ219-2884

 

[MrsTFB]

That easy?! Thanks, this site is even better than before!