Holiday Calculations

  • Thread starter Thread starter KM_Fife
  • Start date Start date
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.
 
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."
 
Back
Top