I've added three new pages to the Code Vault.

The first is a function that will calculate Easter Sunday. You give it a year, and the function will tell you what month and day of that year Easter falls on. It's a crazy calculation: the first Sunday following the first full moon following the Vernal equinox.

The second is a NetWorkDays function for Access. Excel has had this function for years. You specify two dates and the function will tell you how many work days (Mon thru Fri) fall between those dates (inclusive). Also, you can specify a holiday table for date exclusions (days you have off work, like New Year's Day).

The third shows three different ways to calculate someone's exact age in Access. The first is the wrong way that most people use with just DateDiff. The second shows how to calculate it mathematically and is "good enough" for most instances. The third shows the best way, albeit the most complicated one.

The Code Vault is available for subscription for $9 per month.