How do I automatically generate dates?
 

I run two reports every week, and I have my report set up to enter the dates
sent automatically (exporting from Word). My question is how do I set up a
formula so that when the date sent is entered into the respective column, the
due date is entered seven days from that date?
Please Help! I am using MS Office 2003 Excel.

If you have a date in cell A1, you can use this formula in any other cell to
add 7 days to it:
=A1+7
This assumes both cells are formatted as dates. Also see:
http://www.officearticles.com/excel/...soft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"alvoons28" wrote in message
...
I run two reports every week, and I have my report set up to enter the
dates
sent automatically (exporting from Word). My question is how do I set up
a
formula so that when the date sent is entered into the respective column,
the
due date is entered seven days from that date?
Please Help! I am using MS Office 2003 Excel.