Date function in Excel 2000

[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

 

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

 

[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

 

[Ian]

Thanks for the help guys, it's sorted now
Cheers