You'll have to open this into a recordset programatically and loop through comparing each date with the fixed holiday date to get your day count minus holidays. Then you can run the result through the weekday count function to return a final number of working days.I already created a table tblHolidays with fields HolidayID,HolidayDate and HolidayName and enetred all the public holidays in my country.
Thankyou
Jerry
** Admin Edit **
This was moved here from, and is related to, count days.