Put this formula in A1:

=TODAY()-WEEKDAY(TODAY())+1

and apply a custom format to the cell of "mm/dd/yyy - dddd" (without
the quotes). Then in B1 enter the formula:

=A1+1

The format should change to be the same as A1, but if it doesn't then
use the Format Painter to copy the format from A1 to B1. Then just
copy B1 into C1:G1, and then you have your headings, which will change
every Sunday.

I was a bit confused when you said A2 for Monday, but I think this is
what you want.

Hope this helps.

Pete


On Sep 11, 11:40 pm, Ivan Wiegand <Ivan
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?