Creating Spreadsheet with Date Formula

  • Thread starter Thread starter Jschaeffel
  • Start date Start date
J

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?
 
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")
 
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.
 
Back
Top