Creating Spreadsheet with Date Formula

[Jschaeffel]

I need to create a spreadsheet which has a beginning date, 02.10.09 and then
from that date adds, 24 hours, a 4-6 week date range, a 8-10 week range, etc.

Can someone help me get started?

 

[JE McGimpsey]

One way:

A1: 02.10.09

Add 24 hours:
A2: =A1+1

4-6 week date range:
A3: =TEXT(A1+28,"mm.dd.yyyy") & "-" & TEXT(A1+42,"mm.dd.yyyy")

8-10 week date range:
A4: =TEXT(A1+56,"mm.dd.yyyy") & "-" & TEXT(A1+70,"mm.dd.yyyy")

 

[Shane Devenshire]

Hi,

Suppose your start date is in A1 then in B1 enter
=A1+1
In C1 enter
=A1+7*4
In D1 enter
=A1+7*8
Select C11 copy them and chose Edit, Paste Special Values.
Highlight C11 and using the Fill Handle drag down 14 rows or 21 depending
on what exactly you want. When you release the mouse if Excel has copied the
data, click the paste options icon, usually at the bottom right of the
selection, and choose
Fill Days.