# Difference in days including weekends but excluding Holiday Range

1. ## 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!!

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

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

4. Thanks, works perfectly!! Your help is appreciated!

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1