Forum Discussion

MacroMining's avatar
MacroMining
Copper Contributor
Jun 09, 2022

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 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 

 

 

Formulas and Functions

3 Replies

  • mtarler's avatar
    mtarler
    Silver Contributor
    Jun 09, 2022
    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, ... )
    • MacroMining's avatar
      MacroMining
      Copper Contributor
      Jun 09, 2022

      I need the formula to calculate the yellow box.  it must exclude weekends and holidays

      • mtarler's avatar
        mtarler
        Silver Contributor
        Jun 09, 2022

        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

Resources