Duh -- I feel like such an idiot! :)
Thanks to both of you!
"Bernard Liengme" wrote:
A1 has a date
A2 has =A1+7 and displays the date one week on
Copied A2 to A3 and it shows A1 plus 2 weeks (ie A2 plus 7 days)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
"Faith" wrote in message
...
Hi! Can someone tell me how to do this date calculation: I have entered a
starting date (September 1, 2007), and I want to create a calculation that
adds one week to that date over a series of cells (September 1 plus 7
days;
September 8 plus 7 days, and so on). Thanks!