How do I automatically calculate a series of dates 7 weeks from the starting date?

Cell A1 has 1/1/2011.  I want cell A2 to be seven weeks from  cell A1, cell A3 to be seven weeks from cell A2, etc.
bobbatAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Brad Sims, CCNAConnect With a Mentor Network AdministratorCommented:
The simplest way is just to add 49 (the number of days) to the value in A1.

=SUM(A1+49)

0
 
mawniConnect With a Mentor Commented:
I agree with JOHN, there are much functions to do this, but the simplest way is just adding 47
0
 
ashishgamre11Connect With a Mentor Commented:
Yes, you can write
=SUM(A1+49)
in cell A2.

You can drag the formula to A3,A4,.. and onwards.

or write
=SUM(A2+49)
in cell A3

=SUM(A3+49)
in cell A4 .. and onwards
0
 
barry houdiniConnect With a Mentor Commented:
SUM function is unnecessary here, all you need is this formula in A2 copied down

=A1+49

regards, barry
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.