Holiday Calculations

K

KM_Fife

There's probably an easy solution to this query as I suspect this is a common
calculation to make.
I'm wanting to create a query using an employee's last day of work (date) &
the date they start again after holiday that calculates the difference in
dates but ignores weekends so as to calculate the number of days used of
their holiday entitlement.
 
A

Al Campagna

Kevin,
You probably would also want to not count and Company holidays between
those dates too...

On my website (below), under Access Tips I have a 97 and 2003
downloadable version of "Calculate Workdays Between 2 Dates."
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Holiday Database 7
number of months and days between two dates without approximation 3
Add-in WITH worksheets?? 1
WORKDAY and holidays 7
Remove weekday holiday dates from "between dates" 1
Date Diff 6
MS Project. Real progress of the project, % complete 1
Adding days to the WORKDAY function 2

Top