MrExcel Publishing
Your One Stop for Excel Tips & Solutions

date +7 formula


Posted by Linda on December 21, 2001 5:12 PM

Know nothing about excell I need HELP PLEASE

IN CELL K9 is formated with date(TODAY) I need to add 7 days for a RETURN DATE based off K9. The RETURN DATE would be in cell D20

THIS IS DONE EVERYDAY. Please help


Posted by Tom Dickinson on December 21, 2001 5:19 PM

Same as any other value. In D20 you can put

=today() + 7

or

=K9 + 7

I hope you have =Today() in K9 so it automatically updates for the new day.

Welcome to the power of excel

Posted by rm on December 21, 2001 5:21 PM

try typing in cell D20:

=SUM(K9+7)

hope that helped...rm