• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 270
  • Last Modified:

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.
0
bobbat
Asked:
bobbat
4 Solutions
 
Brad Sims, CCNANetwork AdministratorCommented:
The simplest way is just to add 49 (the number of days) to the value in A1.

=SUM(A1+49)

0
 
mawniCommented:
I agree with JOHN, there are much functions to do this, but the simplest way is just adding 47
0
 
ashishgamre11Commented:
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 houdiniCommented:
SUM function is unnecessary here, all you need is this formula in A2 copied down

=A1+49

regards, barry
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now