Date function in Excel 2000

I

Ian

Hi
I'm trying to do a timesheet for work and I want the week to run from
Sunday to Saturdya with a 5 row gap in between each day. Is there any way of
doing this. I've tried fill but it only does it in the next row.
Cheers
Ian
 
B

Bob Phillips

Put the first date in row 1, the second in row 7.
Select the cells in rows 1-12, and just drag and copy.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
M

Mctabish

Try this (and fill down)

=IF(INT(ROW()/6)=ROW()/6,ROW()/6,"")

You may need to play with an offset to get it tweaked just right, but this
should do what you want it to. Just remember to format the cell as CUSTOM
TYPE dddd

HTH
Mc
 
Top