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 automatically Start Date based on the 2 pieces of info, but also ensuring that weekend days are not considered.
This way the date showing, only work days....I am stuck. Any suggestions?
NETWORKDAYS formula wont' work because it needs START DATE and END DATE of the project.
2 Replies
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
