Time sheet date question

Try the following...

B3, copied down to B9:

=IF(MONTH($B$1-(CELL("row",$B$9)-ROW()))=MONTH($B$1),$B$1-(CELL("row",$B$9)-ROW()),"")

B15, copied down to B21:

=$B$1+(ROW()-ROW($B$15)+1)

Hope this helps!

Originally Posted by chapm4

That works great, thanks! The first Monday-Sunday (Cells B4-B10) are correct. Names of the days of the week are in column A, but I changed your formula to B. The problem is that the sheet then skips down to B15 to start the next 7 days. The formula then assumes that the first day is 2/11/2005 when it should be 2/7/2005.

I know this is screwey and would be very easy to rewrite the sheet, but it is one the whole school district uses and I can't redo it.