Hi,

I am working in Access and I want to do a calculation of Date 2 - Date 1. However, I do not want to count weekends or holidays in the calculation. How do you type in the calculation to exclude those weekends and holidays?

Thanks

Doug

Excel has a function called NETWORKDAYS, which takes 2 dates, exludes weekends, and you can pass it a list of holidays to exclude as well. I would check and see if Access has access to this function. It has saved me a whole lot of work in the past.

Hope that helps

Mike

Mike
EchoVue.com