Forum Discussion
Calculate Start Date (work days only)
I am drafting a project plan in Excel, and I am calculating START DATE from the following information - Completion Date - No of days, already pre set for this project I am trying to show aut...
Use the WORKDAY function:
Completion date is in A2, number of days in B2, and the formula for start date in C2 is
=WORKDAY(A2,-B2)
HansVogelaar really appreciate your help! Will apply your formulat to my project sheet. Thanks Hans! Have a good weekend.
Viviana