LOL

I'm not laughing at Richard; but, rather, how easy it is to overlook the
obvious... I think we have all been guilty of that at one time or another.

For the OP... rather than typing in each day name individually, just put the
word Sunday in your first column's first cell and drag it across to place
the other day names into the adjacent cells.

Rick


"Pete_UK" wrote in message
oups.com...
Or you could just put the words "Sunday", "Monday", etc in the second
row - they are not going to change.

Pete

On Sep 12, 3:24 pm, Richard wrote:
You could also enter the suggested formula on 2 rows and format each how
you
want to see it ie once as dd/mmm/yy and once as dddd, so that you get the
date in one cell and the day in another



"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?- Hide quoted text -

- Show quoted text -