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

[FOP38]

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

 

[MartinW]

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]

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