Forum Discussion
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 working days a week?
Thx
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)
- thank you
