Calendar table with holidays in it is definitely the way to go.
The biggest consideration with that is having someone keep the holidays up-to-date, or you end up with a sort of Y2K issue.
You can have it auto-populate the standard ones. But if there are business-specific holidays, or if a new federal holiday is created, there needs to be a well-documented means of handling those. In many companies, HR issues a list of the year's holidays at the end of the prior year, so it can be handled by them, and they can use it to issue the list if you set that up. That works pretty well.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon