workday calculation for backwards

  • Thread starter Thread starter Oscar
  • Start date Start date
O

Oscar

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.
 
=WORKDAY(C1,-B1)

Format as Date

If you get a #NAME error: Tools>Add-ins>Check Analysis Toolpak
 
Back
Top