software

I am trying to make a graph and have daily data for a period of 3 years and
then weekly for an additional year and a half. I want to be able to tell it
start on quot;THIS DAYquot; and end on quot;THAT DAYquot; and it puts the dates in
automatically. Right now I am trying to type them by hand and with over
1000 days that's goint to take me forever.

One way, put start date in A2, assume you put 01/01/01 (US date format thus
Jan 1 2001)

=TEXT(DATE(YEAR(A2) 3,MONTH(A2),DAY(A2))-A2,quot;Generalquot;)

will give you number of days (1095)

In the name box type A2:A1096
press enter, do editgt;fillgt;series, select day and 1 as step value and press
enter
last cell will show 12/31/03

or just grab the fill handle of A2 and copy down

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon

quot;Apple_piquot; gt; wrote in message
...
gt;I am trying to make a graph and have daily data for a period of 3 years and
gt; then weekly for an additional year and a half. I want to be able to tell
gt; it
gt; start on quot;THIS DAYquot; and end on quot;THAT DAYquot; and it puts the dates in
gt; automatically. Right now I am trying to type them by hand and with over
gt; 1000 days that's goint to take me forever.