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


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


regards, barry

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