Calculating consecutive days excluding weekends and holidays

[croud]

Hi there,
I have a report that is exported from another program. I need to identify the number of consectutive days that an employee was out excluding weekends and holidays also the rows could have the same date as the entries could be broken into 1/2 entries for each date. Ideally I would like for excel to identify and count the information all in one column however I realize it may need to be broken into 2 areas. My end goal is to identify when there are 10 or more conecutive days off by 1 employee.

 

[johnny51981]

The NETWORKDAYS function would be what you want. You will need to create a list of Holiday dates you are to observe, and then include that in your formula.
=NETWORKDAYS(From Date, To Date, ListofHolidayDates)

 

[croud]

The NETWORKDAYS function would be what you want. You will need to create a list of Holiday dates you are to observe, and then include that in your formula.
=NETWORKDAYS(From Date, To Date, ListofHolidayDates)

i am not sure that is the answer I am looking for, at least not entirely. I believe I also need a countif I'm just unsure of to incorporate it. I need the enteries for each employee counted to know if they have missed 10 or more days (my apologies for the huge omission of that information in my original post). I am trying to make a very complicated and time consuming reconciliation eport a little easier by making these days stand out.

 

[johnny51981]

There is probably a way with Power Query...but a formula I can't quite get there.

 

[croud]

There is probably a way with Power Query...but a formula I can't quite get there.

Thank you for trying I took a step back and realized it's possible I can use a pivot table to accomplish what I am looking for. Thank you for your time!