You really need a table of holidays for your local area.
For example, yesterday (Monday 17 May 2004) was a holiday where I live. It
maybe wasn't where >you< live. There is no way that any general-puropose
function within Access VBA, could know all the holiday dates for all world
regions.