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.
Who is Participating?

Improve company productivity with a Business Account.Sign Up

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.


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

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

or write
in cell A3

in cell A4 .. and onwards
barry houdiniConnect With a Mentor Commented:
SUM function is unnecessary here, all you need is this formula in A2 copied down


regards, barry
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.