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

F

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
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top