The question was:
Need to create series with dates in intervals of 6 weeks 24 weeks and 52 weeks. want it to be set to do it automatically. Can anyone help me?
The answer is simple. You can use the Excel Date functions to do this:
To break down what is happening here, using “24 weeks from today”, as an example.
The formula is <- (168 days equals 7 days time 24 weeks)
=DATE(YEAR(B2),MONTH(B2), DAY(B2)+168)
=DATE(2009,MONTH(B2), DAY(B2)+168)
=DATE(2009,12, DAY(B2)+168)
=DATE(2009,12,29+168)
=15 June 2010
Update:
Another way to do this is by using the TODAY verb.
ie. =TODAY()+168
(with thanks to The Angry Technician)
For adding or subtracting any period that can be expressed as a whole number of days, there is a much simpler way of doing this, at least in Excel 2007. Simply adding the required number of days to the date value. For example, if I fill in the following formula today (4th Jan):
=TODAY()+168
The calculated result is 21/06/2010.
For adding months, you would need to use a more complicated formula as the number of days per month varies.
Thanks Angry Technician, I’ll add it to the post.