Hello everyone.
I am attempting to calculate the number of working days over a period of time for my company. I found a neat tutorial to write a public function that calculates the number of days between two dates that aren't Saturday or Sunday.
http://www.databasejournal.com/features/msaccess/print.php/1552691
However, my company gives its employees many days off that aren't Saturday or Sunday. Most of the employees get every other Friday off, as well as pretty much every federal holiday.
What I need is a way to modify that function to also ignore "holidays." At the end, the article mentions using a query extract from a table containing all the holidays for the year, to increase accuracy.
How do I do this? I already have a table, I just need to know what to add to the function to make it access the table when determining dates.
Thanks in advance.
I am attempting to calculate the number of working days over a period of time for my company. I found a neat tutorial to write a public function that calculates the number of days between two dates that aren't Saturday or Sunday.
http://www.databasejournal.com/features/msaccess/print.php/1552691
However, my company gives its employees many days off that aren't Saturday or Sunday. Most of the employees get every other Friday off, as well as pretty much every federal holiday.
What I need is a way to modify that function to also ignore "holidays." At the end, the article mentions using a query extract from a table containing all the holidays for the year, to increase accuracy.
How do I do this? I already have a table, I just need to know what to add to the function to make it access the table when determining dates.
Thanks in advance.
