workday calculation for backwards

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

Niek Otten

=WORKDAY(C1,-B1)

Format as Date

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Project. Real progress of the project, % complete 1
Looking for a way to Force Successor Task to next workday IF 'x' amount of time left in workday 0
Help using the Workday Function 1
Date Calculation - Astro Calculation 0
Receiving unexpected Duration 0
How to shift a weekend date to the last or next workday 2
Weighted % Complete calculation 1
Workday Problem 4

Top