If C2 is Sunday how do I make D 2 to the next day of the week
 

In my schedule I type the start date in cell A2 and in cell C2 it
automatically set the date seven days later. In cells C5, D5, E5, F5, G5,
H5, I5, J5, it calculates the date (10/21, 10/22, ect). Above these cells I
would like to have the day of the week calculated by the date below that cell.

A2 C2
10/21/07 10-28-07


C4 D4 E4 F4 G4
H4 I4 J4
Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sunday
C5 D5 E5 F5 G5
H5 I5 J5
10/21 10/22 10/23 10/24 10/25 10/26
10/27 10/28

If C2 is Sunday how do I make D 2 to the next day of the week
 

Hi FOP,

Put this in cell C4 and drag across as far as is needed.
=WEEKDAY(C5)

Then format your cells as custom dddd

HTH
Martin



"FOP38" wrote in message
...
In my schedule I type the start date in cell A2 and in cell C2 it
automatically set the date seven days later. In cells C5, D5, E5, F5, G5,
H5, I5, J5, it calculates the date (10/21, 10/22, ect). Above these cells
I
would like to have the day of the week calculated by the date below that
cell.

A2 C2
10/21/07 10-28-07


C4 D4 E4 F4 G4
H4 I4 J4
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
Sunday
C5 D5 E5 F5 G5
H5 I5 J5
10/21 10/22 10/23 10/24 10/25 10/26
10/27 10/28

If C2 is Sunday how do I make D 2 to the next day of the week
 

"MartinW" wrote:

Hi FOP,

Put this in cell C4 and drag across as far as is needed.
=WEEKDAY(C5)

Then format your cells as custom dddd

HTH
Martin



"FOP38" wrote in message
...
In my schedule I type the start date in cell A2 and in cell C2 it
automatically set the date seven days later. In cells C5, D5, E5, F5, G5,
H5, I5, J5, it calculates the date (10/21, 10/22, ect). Above these cells
I
would like to have the day of the week calculated by the date below that
cell.

A2 C2
10/21/07 10-28-07


C4 D4 E4 F4 G4
H4 I4 J4
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
Sunday
C5 D5 E5 F5 G5
H5 I5 J5
10/21 10/22 10/23 10/24 10/25 10/26
10/27 10/28