How Many Days Until Thanksgiving? Dates for 2026 to 2031 and an Excel Countdown

shape
shape
shape
shape
shape
shape
shape
shape
How Many Days Until Thanksgiving? Dates for 2026 to 2031 and an Excel Countdown - featured image

Thanksgiving in the United States falls on the fourth Thursday of November. In 2026 it is on Thursday, November 26. If today is November 18, 2026, there are 8 days left, which is one week and one day. This page shows the date for every year from 2026 to 2031, explains the rule, shows how to count the days by hand and in Excel, and gives a simple planning timeline for the last two weeks before the holiday. You can also use it to find how many days remain between Thanksgiving and Christmas, so you can plan shopping, travel and cooking with the correct numbers.

Updated November 2026

In this guide

  1. Thanksgiving dates from 2026 to 2031
  2. The rule behind the date
  3. How to count the days by hand
  4. Excel formula for the countdown
  5. Find Thanksgiving for any year in Excel
  6. Days between Thanksgiving and Christmas
  7. A two-week planning timeline
  8. What is the day after Thanksgiving?
  9. Thanksgiving in other countries
  10. Hours, minutes and weeks left
  11. Make a countdown sheet
  12. Common mistakes
  13. Practice problems
  14. Quick summary

Thanksgiving dates from 2026 to 2031

The date changes every year, because the holiday is tied to a weekday and not to a number. It can fall on any date from November 22 to November 28. Here are the dates for the next six years.

YearDateWeekdayDays to Christmas
2026November 26Thursday29
2027November 25Thursday30
2028November 23Thursday32
2029November 22Thursday33
2030November 28Thursday27
2031November 27Thursday28
Days Until December 1st Calculator screenshot used in the guide: How Many Days Until Thanksgiving? Dates for 2026 to 2031 and an Excel Countdown
Check your answer with our free Days Until December 1st Calculator.

The rule behind the date

Thanksgiving is on the fourth Thursday of November. To find it, look at what weekday November 1 is. The first Thursday is the first one on or after November 1, and the fourth Thursday is exactly 21 days later. In 2026, November 1 is a Sunday, so the first Thursday is November 5, and the fourth is November 5 plus 21 days, which is November 26. Note that the fourth Thursday is not always the last Thursday. In 2030, November 1 is a Friday, so the Thursdays are on 7, 14, 21 and 28, and the fourth is the 28th, which is also the last. In 2026, the Thursdays are on 5, 12, 19 and 26, and there is no fifth one.

How to count the days by hand

Subtract today from Thanksgiving. If it is November 18 and Thanksgiving is November 26, the difference is 26 minus 18, which is 8 days. When the two dates are in different months, count the days left in the current month, then add the days in the next month. From October 24 to November 26, there are 7 days left in October after the 24th, because October has 31 days, plus 26 days in November, which makes 33 days. Decide whether you count today. Most countdowns do not count the current day, so 8 days from the 18th means the 26th.

Excel formula for the countdown

In Excel, you can subtract two dates directly. If Thanksgiving is in cell B1 and today is given by the TODAY function, use =B1-TODAY(). Format the result as a General number, because Excel may show it as a date. For 2026, type =DATE(2026,11,26)-TODAY(), and on November 18 the result is 8. To show weeks and days, use =INT((B1-TODAY())/7)&" weeks "&MOD(B1-TODAY(),7)&" days", which gives 1 weeks 1 days on November 18. Our DATEDIF guide shows other ways to count between dates.

Find Thanksgiving for any year in Excel

You do not need a list of dates. For any year in cell A1, use =DATE(A1,11,1)+MOD(5-WEEKDAY(DATE(A1,11,1)),7)+21. WEEKDAY returns 1 for Sunday and 5 for Thursday. The MOD part counts the days from November 1 to the first Thursday, and the 21 moves to the fourth Thursday. Test it for 2026. November 1 is a Sunday, so WEEKDAY is 1, and MOD of 4 and 7 is 4, so the first Thursday is November 5. Add 21 and you get November 26. Format the cell as a date. Fill the formula down a list of years to build your own table.

Days between Thanksgiving and Christmas

Many people plan gifts and travel around the gap between the two holidays. In 2026 Thanksgiving is on November 26 and Christmas is on December 25, so the gap is 29 days, which is four weeks and one day. In 2030 the gap is only 27 days, because Thanksgiving is as late as it can be. When Thanksgiving is early, as in 2029 on November 22, there are 33 days. Use this gap to plan when to order gifts, when to send cards and when to book travel. Our days until Christmas page has the full countdown.

A two-week planning timeline

Use the countdown to plan. Fourteen days before, which is November 12 in 2026, decide the guest list and the menu. Ten days before, order a turkey if you need a fresh one. A frozen turkey needs time to thaw in the fridge, about one day for every 4 to 5 pounds, so a 16-pound turkey needs 3 to 4 days, which means starting on Sunday or Monday. Seven days before, buy the non-perishable food and the drinks. Three days before, shop for fresh food and clean the house. On the day before, prepare the side dishes and the pies.

What is the day after Thanksgiving?

The Friday after Thanksgiving is known as Black Friday, the start of the holiday shopping season. In 2026 it falls on November 27. The following Monday is called Cyber Monday, which is November 30 in 2026. If you are counting days to a sale, add one day to the Thanksgiving countdown for Black Friday and four days for Cyber Monday. On November 18, 2026 that makes 9 days to Black Friday and 12 days to Cyber Monday. Many stores now start their sales earlier, so check the exact dates of the shops you use.

Thanksgiving in other countries

The United States is not the only country with a Thanksgiving. Canada celebrates it on the second Monday of October, which is October 12 in 2026. The two holidays have different dates because the harvest comes earlier in the north. If you ask how many days until Thanksgiving in Canada, use that date instead. In Excel, the second Monday of October for a year in A1 is =DATE(A1,10,1)+MOD(2-WEEKDAY(DATE(A1,10,1)),7)+7. For 2026, October 1 is a Thursday with WEEKDAY of 5, MOD of negative 3 and 7 is 4, so the first Monday is October 5, and the second is October 12.

Hours, minutes and weeks left

You can express the countdown in other units. Eight days is 8 times 24, which is 192 hours. In minutes, 192 hours is 192 times 60, which is 11,520 minutes. In weeks, 8 days is 1.14 weeks. These conversions are handy for a countdown poster or a school activity. Our minutes to hours converter and our weeks in a year guide help with other conversions. Remember that the numbers change every day, so use the TODAY formula for a live count.

Make a countdown sheet

Build a small sheet for the family or the office. In A1 type the holiday name, in B1 the date and in C1 the formula =B1-TODAY(). Add rows for Black Friday, Christmas and New Year. Use conditional formatting to turn the cell red when the number is less than 7. Copy the layout to other events, such as birthdays, trips and deadlines. Our days until December 1st calculator works in the same way, and it is a good tool to use for a quick check.

Common mistakes

The most common mistake is to think that Thanksgiving is on the last Thursday of November. It is the fourth Thursday, and the two are the same only when the month has four Thursdays. Another is to confuse the American and Canadian dates. A third is to count today and get a result that is one day too high. A fourth is to forget that Excel shows a subtraction of dates as a date until you change the format to General. A fifth is to type the date as text, so the formula returns a value error.

Practice problems

Try these. Problem 1: if today is November 10, 2026, how many days are left? The answer is 16. Problem 2: what weekday is Thanksgiving in 2027? Thursday. Problem 3: how many days are there between Thanksgiving 2028 and Christmas? The answer is 32. Problem 4: if a 20-pound turkey needs one day of thawing for every 5 pounds, how many days does it need? Four days. Problem 5: use the Excel formula to find Thanksgiving in 2032, which is November 25.

Quick summary

Thanksgiving is on the fourth Thursday of November, which is November 26 in 2026. Subtract today from that date to find the days left, or use the TODAY function in Excel. The date moves between November 22 and November 28 from year to year. Plan the menu two weeks ahead, thaw the turkey several days before, and use the gap to Christmas, which is 29 days in 2026, to plan the rest of the season. For other countdowns, change the date in the formula and the sheet works for any event.

Frequently asked questions

How many days until Thanksgiving 2026?

Thanksgiving 2026 is on November 26. On November 18 there are 8 days left.

What day is Thanksgiving?

The fourth Thursday of November.

What is the earliest and latest date for Thanksgiving?

November 22 is the earliest and November 28 is the latest.

How many days between Thanksgiving and Christmas in 2026?

There are 29 days.

When is Canadian Thanksgiving?

The second Monday of October.

Related guides and free tools

Leave a Reply

Your email address will not be published. Required fields are marked *