Excel Thanksgiving Date Formulas

It’s Thanksgiving here in Canada, so I’m taking the day off.And if you’d like to know when the USA Thanksgiving occurs this year, keep reading!

All Signs Point to Excel

Below is a photo from my travels last week.

This tiny snack bar is selling something we should all be thankful for — Excel!

I’m sure you’ll agree that Microsoft Excel should be available almost everywhere! It’s nearly as important as water, for getting through the day.

When Is USA Thanksgiving?

Some holidays are celebrated on the same date every year, like New Year’s Day, Canada Day, and Christmas.

Other holidays are the Nth weekday in a specific month. For example, USA Thanksgiving occurs on the 4th Thursday in November

To calculate the date, use one of the formulas on the Find Nth Weekday in Month page, on my Contextures site.

Video: Find Nth Weekday

[Update} I made this video in 2022, and the formula uses the WORKDAY.INTL function, which is available in Excel 2010 or later

This video shows how to find the Nth weekday in a specific month and year, by using the WORKDAY.INTL function in an Excel formula.This function is available in Excel 2010 or later.

To calculate the date in earlier versions of Excel, use one of the WEEKDAY formulas on the Find Nth Weekday in Month page, on my Contextures site.