Forum Discussion
Orgo123
Mar 04, 2024Copper Contributor
Excel question > calculate workdays
Hi, I have task that need to end at 31-Mar. the working days to finish this task is 7 days. ho do I calculate what should be the start date in order to finish at the 31-Mar when I have only 5 work...
HansVogelaar
Mar 04, 2024MVP
Let's say the end date 31-Mar is in E2 and the number of working days in F2.
The formula for the start date is
=WORKDAY(WORKDAY(E2+1,-1),1-F2)
- Orgo123Mar 04, 2024Copper Contributorthank you