Date function in Excel 2000

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

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)


"Ian" <ian@ilockett.freeserve.co.uk> wrote in message
news:diuifk$1eq$1@newsg3.svr.pol.co.uk...
> 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
>
>

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" <ian@ilockett.freeserve.co.uk> wrote in message
news:diuifk$1eq$1@newsg3.svr.pol.co.uk...
> 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
>

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