View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default 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.