NetWorkDays in Access

[khughes46]

Does anyone have a NetWorkDays calculation for Access like the one used in Excel. I have seen one that uses just Date1 and Date2 but does not include a holiday exclusion. I need one that includes a holiday exclusion. I have this working in an Excel spreadsheet, but would like to include it in my DB and avoid extra export steps. Thanks for any help or suggestions.

[June7]

This is a common topic. Search forum or web for many examples. Excluding holidays requires maintaining a Holidays table. Adapt code to incorporate a check against the Holidays table.
https://www.accessforums.net/queries...ays-51341.html

[CJ_London]

you could modify the code you found to include an additional parameter for holiday dates.

Alternatively, create a table to list the holidays and modify the function you found to count the number of holiday dates between date1 and date2 - something like dcount("*","tblHolidays","HolDate between date1 and date2")

There are a number of possible other solutions which you will find in this and other forums which typically calculate the end date from a start date and allowing for weekends and holidays (or visa versa) which could also be adapted

[CJ_London]

here's another link

http://www.access-programmers.co.uk/...=holiday+dates

[CJ_London]

and another

http://www.access-programmers.co.uk/...=holiday+dates