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.
|