Most of you are probably already aware of the FORMULAS page on my site. These are commonly requested formulas that I post for others to use. Most can be copied and pasted into your reports with minimal modification.

Formula #26 (written by Mike Cook) generates a list of the most common US holidays, based on the year you input. This is useful if you have to do business days calculations and don’t want to manually maintain the list of holidays. But, this morning I received a message that the formula doesn’t pick the correct date for Thanksgiving in years where November starts on a Thursday (like in 2007). I have posted a corrected formula. If some of you are using this formula in your reports then please update the line for Thanksgiving (element 6).

Thanks to Francis Moran for pointing out the error.