| 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 |
| 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) | |||
Threaded Mode
