| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to change week-offs from saturday and sundays to sunday and mo | Excel Discussion (Misc queries) | |||
| How do I make a to do chart for every day of the week? | Charts and Charting in Excel | |||
| How do I make a one-week calendar? | Excel Discussion (Misc queries) | |||
| I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) | |||
| How do I make a Custom Datre Format ie 01.01.05 WK1 (WK is Week 1) sorry about previous post | Excel Discussion (Misc queries) | |||
Linear Mode
