Difference in days including weekends but excluding Holiday Range

Hello,

I have scoured all over but am unable to get a reasonable solution. Hpw do I find the number of days between two dates including weekends but excluding a range of holidays.

Networkingdays works but I have to get rid of the weekends in it which I dont want to. I would appreciate a simple non VBA solution as I am not very coding savvy.

Thanks for reading!!

If you have start date in A2 and end date in B2, with holiday dates in H1:H10,

=B2-A2-SUMPRODUCT(1-ISNA(MATCH(ROW(INDIRECT(A2&":"&B2)),H1:H10,0)))+1

Like NETWORKDAYS the count will include both start and end dates

Originally Posted by Doughnut

Hello,

I have scoured all over but am unable to get a reasonable solution. Hpw do I find the number of days between two dates including weekends but excluding a range of holidays.

Networkingdays works but I have to get rid of the weekends in it which I dont want to. I would appreciate a simple non VBA solution as I am not very coding savvy.

Thanks for reading!!

Hi,

1. Name your start date cell 'Start' and the end date cell 'End'.
2. Create a table of holiday dates in say A5:Ann and in the cells to the right of the dates in B5 enter the formula and copy down:

Please Login or Register  to view this content.

3. Put a total formula in B4 and name it HolTotal

Please Login or Register  to view this content.

Now your net days excluding holidays is the formula:

Please Login or Register  to view this content.

HTH

Thanks, works perfectly!! Your help is appreciated!