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:
3. Put a total formula in B4 and name it HolTotal
Now your net days excluding holidays is the formula:
HTH
Bookmarks