Hi

Formatting a cell as dddd will show the day of the week of the date
entered in that cell.
If the date entered was a Sunday date, it will show Sunday. If the date
is a Thursday date e.g. 11 Jul 2007, then it will show Thursday.

How do I set it up so that all days change when I put the start date
and end date at the top of the sheet?
From your original posting, it sounded as through you were entering the
start date for the period in a cell at the top of the sheet.
What I was saying, was you need to create a reference to that cell, in
the cell where you want Thursday to appear.
If that happens to be cell A15, then in A15 enter
=A1 or whatever is the cell reference where you have entered your
start date.

In cell A16 enter
=A15+1 this will set the date to be one day later than the start date,
and when formatted as dddd, it will show Friday

If you then copy this formula down column A for the next 12 cells, the
formula will alter to A16+1, A17+1 etc. and the dates will step up
accordingly, and thus the actual day shown in the cell will step up to
Saturday, Sunday, Monday etc.


--
Regards

Roger Govier


"cainart" wrote in message
...
One more thing I think need a code for thursday, the dddd is for
sunday.

"Roger Govier" wrote:

Hi

Starting with the cell representing the first day - let's assume this
is
cell A5, enter
=A1 where A1 represents the cell location where you have entered
start
date.

In A6 enter =
A5+1 and copy down.
Format the cells, FormatCellNumberCustom dddd


--
Regards

Roger Govier


"cainart" wrote in message
...
I downloaded a Bi-weekly timesheet for Excel. The timesheet is
perfect
except for the date part. The time sheet comes with a Monday to
Friday
bi-weekly time set-up and I need to change it to a Thursday to
Wednesday
bi-weekly time set-up. At present I had to individually change the
days
starting with the Thursday and when I change the start date and
ending
dates
the only days that automatically change are the first Thursday to
Sunday
settings (4 days). How do I set it up so that all days change when
I
put the
start date and end date at the top of the sheet?