View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default 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?