I'm not that good with Excel, so there could be something very visible I'm
missing.

I have a date for the beginning of the week "6/18/2007" in F4.

I then have five cells that stand for the days of the week. I want to be
able to enter Monday's date (18) and put a equation in the five cells that
will calculate their dates automatically.

I think I have to transfer 6/18/2007 into Excel numbers, which is 39251. And
then put it back into regular time with the DAY function.

=DAY((DATEVALUE(F4))+Y)
Y being adjustment for the date (ex. +2 for Wendsday.

But I get an error. Any help would be welcome.