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
