Archive of Mr Excel Message Board
Back to Dates in Excel archive index
Back to archive home
date +7 formulaPosted 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
Re: date +7 formulaPosted by Tom Dickinson on December 21, 2001 5:19 PM
Same as any other value. In D20 you can put
=today() + 7
=K9 + 7
I hope you have =Today() in K9 so it automatically updates for the new day.
Welcome to the power of excel
Re: date +7 formulaPosted by rm on December 21, 2001 5:21 PM
try typing in cell D20:
hope that helped...rm
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.