Creating Spreadsheet with Date Formula
 

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?

Creating Spreadsheet with Date Formula
 

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")

In article ,
Jschaeffel wrote:

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?

Creating Spreadsheet with Date Formula
 

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 C1:D1 copy them and chose Edit, Paste Special Values.
Highlight C1:D1 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.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Jschaeffel" wrote:

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?