LillyC
asked on
How to calculate working days in a query in MS Access
Does anyone know how I can create a query to calculate the number of working days from between two dates?
When using such functions/calculations in a larger environment (company), across multiple areas with different holidays, then the only approach is the simple approach:
Use a prefilled calendar table and mark the work days.
Use a prefilled calendar table and mark the work days.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
hmm, I guess it depends on the place you're livening. We have in Bavaria already three different calendars for holidays depending on the city (Augsburg - an additional peace festival for the peace treaty after the 30 years war, and depending on the majority of either Catholics or Protestants).. ;)
https://www.experts-exchange.com/questions/27587434/Weekdays-calculation-Access-VBA-2010.html?anchorAnswerId=37596779#a37596779
to exclude holidays see yhis
https://www.experts-exchange.com/questions/23339871/Difference-between-dates-excluding-weekends-holidays.html?anchorAnswerId=21601621#a21601621