| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CALCULATE DUE DATE & RESTART DATE
I need to calculate due after adding certain number of months and days to a
given date. A1 is having a date say 21-Jun-08, in A2 I will enter 12 months & in A3 I will enter 1 day. In A4 I need calculated due date after 12 months & 1 day, which is 21-Jun-09.Then finally a calculated restart date in A6 after a shutdown of 12 days, these 12 days will be entered in A5. XYZ company will complete its operating period of 12M & 1D on 21-Jun-09 and will shut down on 22-Jun-09 to restart on 3-Jul-09 after 12 shutdown days. It took me long to explain but I need this at my job. Any help will be highly appreciate. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Tricky Date calculation: How to calculate a future date | Excel Discussion (Misc queries) | |||
| Auto calculate for date + days forward to yield new date | Excel Worksheet Functions | |||
| formula to calculate age using birth date and current date | Excel Worksheet Functions | |||
| formula to calculate future date from date in cell plus days | Excel Worksheet Functions | |||
| Calculate month-end date from date in adjacent cell? | Excel Worksheet Functions | |||
Threaded Mode
