Project working days overdue calculation

%3CLINGO-SUB%20id%3D%22lingo-sub-3487903%22%20slang%3D%22en-US%22%3EProject%20working%20days%20overdue%20calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3487903%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20day%20Members%3C%2FP%3E%3CP%3EI%20need%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20calculate%20the%20number%20of%20working%20days%20from%20the%20day%20the%20project%20was%20supposed%20to%20end.%26nbsp%3B%20Our%20working%20days%20exclude%20weekends%20(Saturday%20and%20Sundays)%20and%20public%20holidays.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eexample%3A%3C%2FP%3E%3CP%3EStarting%20date%20%2F%20Duration%20%3D%20Ending%20date%26nbsp%3B%3C%2FP%3E%3CP%3Efor%20this%20I%20used%3A%3C%2FP%3E%3CP%3E%3Dworkday.intl(start%20date%2C%20duration%2C%20%5BWeekends%5D%2C%5BHolidays%22%5D)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ehow%20do%20i%20calculate%20the%20number%20of%20days%20excluding%20weekends%20and%20holidays%20from%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3487903%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3487990%22%20slang%3D%22en-US%22%3ERe%3A%20Project%20working%20days%20overdue%20calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3487990%22%20slang%3D%22en-US%22%3EI%20would%20use%3A%20%3DNETWORKDAYS.INTL(%5Bstart_date%5D%2C%20%5Bend_date%5D%2C%20%5Bweekend%5D%2C%20%5BHolidays%5D)%3CBR%20%2F%3Egive%20refs%20to%20the%20start%20date%2C%20end%20date%2C%20use%201%20for%20Sat%2FSun%20weekend%2C%20and%20then%20a%20ref%20to%20a%20range%20that%20has%20dates%20that%20are%20considered%20holidays%20(e.g.%20%24Z%241%3A%24Z%2410%20which%20has%20the%20days%202022-01-01%2C%20...%20)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3488024%22%20slang%3D%22en-US%22%3ERe%3A%20Project%20working%20days%20overdue%20calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3488024%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%221.jpg%22%20style%3D%22width%3A%20672px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%221.jpg%22%20style%3D%22width%3A%20672px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%221.jpg%22%20style%3D%22width%3A%20672px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%221.jpg%22%20style%3D%22width%3A%20672px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F378964i2E9CAA789F0AAF88%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%221.jpg%22%20alt%3D%221.jpg%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20need%20the%20formula%20to%20calculate%20the%20yellow%20box.%26nbsp%3B%20it%20must%20exclude%20weekends%20and%20holidays%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3488126%22%20slang%3D%22en-US%22%3ERe%3A%20Project%20working%20days%20overdue%20calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3488126%22%20slang%3D%22en-US%22%3E%3CP%3Eok%20but%20I%20still%20have%20no%20idea%20what%20cells%20those%20are.%20Is%20Starting%20date%20in%20column%20A%3F%20Is%20the%20first%20date%20in%20row%202%3F%20And%20where%20is%20your%20column%20of%20holidays%20that%20your%20company%20observes%3F%20Assuming%20the%20%22Starting%20date%22%20is%20cell%20A1%20and%20you%20put%20a%20list%20of%20Holidays%20in%20the%20range%20Z1%3AZ10%20then%20in%20F2%20type%3A%3CBR%20%2F%3E%3DNETWORKDAYS.INTL(%20A2%2C%20E2%2C%201%2C%20%24Z%241%3A%24Z%2410)%3CBR%20%2F%3Eand%20copy%20down%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 

 

 

3 Replies
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, ... )

1.jpg

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