Hi Ivan,

If you enter the date in A1 and then in B1 you enter the formula = A1+1 and
drag that formula across to the end of the week then you only have to change
the date in cell A1 each week.

Regards,

OssieMac

"Ivan Wiegand" wrote:

What I'm trying to create is a sort of calendar that has the 7 days of the
week as the column headers. I want the headers to display the day of the week
and the date depending on what week it is. So if it's the week of September
9th, I want A1 to show 9/9/2007 - Sunday, A2 would be 9/10/2007 - Monday,
etc. Then, the following week I want the headers to change so that A1 is now
9/16/2007 - Sunday.

Of course, this is simple to do manually but I don't want to have to change
the headers every Sunday... is this even possible?