Add a week from original cell?

michaeljohannes

Registered User.
Local time
Yesterday, 20:40
Joined
May 3, 2007
Messages
67
Hello,

Can someone help me with a formula to do the following:

I'd like to have cell A1 to be a start date. A2:A9 will equal A1 Date adding a week respectively.

so if A1 = 1/1/2007 then A2 = 1/8/2007, A3 = 1/15/2007, A4 = 1/23/2007 etc.

Thank you for your time!

Mike :)
 
nevermind... i'm stupid! it's simply

a2 = a1+7

when a1 = a date field

sorry to waste your time
 

Users who are viewing this thread

Back
Top Bottom