Number of Holidays between two date

kigor

Registered User.
Local time
Today, 23:04
Joined
Apr 24, 2010
Messages
19
Hi,
I know problem can be simple. I have start date, end date, table with holidays. Problem is I have addition criteria, day(s) of week.
For example from January 1, 2010 to December 31, 2010 I will work for example Monday, Friday and Saturday. Question is how many days I will work excluding holidays.
I have to receive in the end three number:
1. total number of days: this is simple Datediff
2. Number of potentital work day. For it I made query what count number of Monday, Friday and Saturday.
3. real number days, so without holidays. For example May 1 is Saturday so not work.

How can I do it? Possible in simple query?
 
Hello,
This is in big part what I looking for.
HitechCoach example file is great. But how to receive just number of holidays between two date in query?
 
Well if you know the number of weekday between two dates and you know the total number of days between those two dates, then logically the difference between those two results will be the number of holidays.
 
Last edited:

Users who are viewing this thread

Back
Top Bottom