Formula to generate Canadian holiday list

Monday 11 June 2007 @ 6:45 pm

One of my most used formulas is my “Business Days” formula which allows you to calculate the number of business days between any two dates. But to do this you have to store a list of the holidays for each year. One of my readers (Mike Cook of Shepherd Hardware Products) provided a formula to calculate the common US holidays – even going so far as to provide a formula to calculate Good Friday, a pretty amazing feat. Now one of my Canadian readers (Greg Fendall at net-linx Americas) has provided the Canadian version of the holiday formula. If anyone would like to provide the formula for another country I will be happy to post it.

(For examples of my most popular formulas, please visit the FORMULAS page on my website.)







Leave a Reply

Jeff-Net
Recrystallize Pro

Crystal Reports Server