| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
workday calculation for backwards
I have already set up the scheduled completion date and working duration,
want a fomula to calculate the scheduled start date(work day). eg: A B C Start Date Duration Complete date 10 30-Oct-09 I need to know which workday on the columu "A" . Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
workday calculation for backwards
=WORKDAY(C1,-B1)
Format as Date If you get a #NAME error: ToolsAdd-insCheck Analysis Toolpak -- Kind regards, Niek Otten Microsoft MVP - Excel "Oscar" wrote in message ... I have already set up the scheduled completion date and working duration, want a fomula to calculate the scheduled start date(work day). eg: A B C Start Date Duration Complete date 10 30-Oct-09 I need to know which workday on the columu "A" . Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Workday calculation | Excel Discussion (Misc queries) | |||
| Backwards LookUp | Excel Discussion (Misc queries) | |||
| The A,B,C,D at the top of my page are backwards | Excel Discussion (Misc queries) | |||
| Workday Date Calculation | Excel Worksheet Functions | |||
| Workday calculation - not working | Excel Worksheet Functions | |||
Linear Mode
