I'm trying to create a sub to count how many days between 2 dates excluding Holiday and weekend. Using the DateDiff() function is not allowing me to exclude certain days.
Any help in will be appreciated.
I'm trying to create a sub to count how many days between 2 dates excluding Holiday and weekend. Using the DateDiff() function is not allowing me to exclude certain days.
Any help in will be appreciated.
This is a common topic. If you look to the bottom of this thread you will see a number of threads on the same subject.
Thank You. I found one of the post helpful to resolve my issue.