Forum Discussion
Project working days overdue calculation
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 ho...
I would use: =NETWORKDAYS.INTL([start_date], [end_date], [weekend], [Holidays])
give refs to the start date, end date, use 1 for Sat/Sun weekend, and then a ref to a range that has dates that are considered holidays (e.g. $Z$1:$Z$10 which has the days 2022-01-01, ... )
give refs to the start date, end date, use 1 for Sat/Sun weekend, and then a ref to a range that has dates that are considered holidays (e.g. $Z$1:$Z$10 which has the days 2022-01-01, ... )
I need the formula to calculate the yellow box. it must exclude weekends and holidays
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
