Jun 09 2022 07:32 AM
Good day Members
I need help.
I need to calculate the number of working days from the day the project was supposed to end. Our working days exclude weekends (Saturday and Sundays) and public holidays.
example:
Starting date / Duration = Ending date
for this I used:
=workday.intl(start date, duration, [Weekends],[Holidays"])
how do i calculate the number of days excluding weekends and holidays from
Jun 09 2022 07:41 AM
Jun 09 2022 07:51 AM
I need the formula to calculate the yellow box. it must exclude weekends and holidays
Jun 09 2022 08:16 AM - edited Jun 09 2022 08:17 AM
ok but I still have no idea what cells those are. Is Starting date in column A? Is the first date in row 2? And where is your column of holidays that your company observes? Assuming the "Starting date" is cell A1 and you put a list of Holidays in the range Z1:Z10 then in F2 type:
=NETWORKDAYS.INTL( A2, E2, 1, $Z$1:$Z$10)
and copy down