How Many Days Until Christmas 2026? Countdown, Weeks and Excel Formula

shape
shape
shape
shape
shape
shape
shape
shape
How Many Days Until Christmas 2026? Countdown, Weeks and Excel Formula - featured image

Christmas Day in 2026 falls on Friday, 25 December. On 18 November 2026, there are 37 days left until Christmas, which is 5 weeks and 2 days, or 888 hours. The number shrinks by one every day, so this guide gives you a countdown table for every key date in the season, shows how to work out the days yourself in your head or on paper, explains the difference between counting calendar days and working days, and gives you an Excel formula that always shows today’s countdown. It also covers how to plan a gift, shipping and cooking schedule by counting backward from 25 December, with worked examples.

Updated November 2026

In this guide

  1. The quick answer for 2026
  2. Countdown table: days left on key dates
  3. How to count the days yourself
  4. Weeks until Christmas
  5. Calendar days vs working days
  6. Excel formula that updates every day
  7. Plan backward from Christmas
  8. Sample Christmas planner with dates
  9. Days until other dates
  10. Why the number differs between sites
  11. Countdown ideas for kids and classrooms
  12. Practice problems
  13. Common mistakes

The quick answer for 2026

Christmas Day is Friday, 25 December 2026. Counting from 18 November 2026, you get 12 days left in November, since 30 minus 18 is 12, plus 25 days in December, which makes 37 days. In weeks, that is 5 full weeks and 2 extra days. In hours it is 37 times 24, or 888 hours, and in minutes it is 888 times 60, or 53,280 minutes. We do not count today in this total. If you want to include today, add one day. For any other date, use the table below or the formula later in this guide.

Days Until December 1st Calculator screenshot used in the guide: How Many Days Until Christmas 2026? Countdown, Weeks and Excel Formula
Check your answer with our free Days Until December 1st Calculator.

Countdown table: days left on key dates

The table shows the number of days from each date to Christmas Day, 25 December 2026, not counting the starting date.

DateDays until ChristmasWeeks and days
1 November547 weeks 5 days
15 November405 weeks 5 days
18 November375 weeks 2 days
26 November (Thanksgiving)294 weeks 1 day
27 November (Black Friday)284 weeks
30 November (Cyber Monday)253 weeks 4 days
1 December243 weeks 3 days
10 December152 weeks 1 day
15 December101 week 3 days
20 December55 days
24 December11 day

Each row is easy to check: from 1 November to 30 November is 29 days, and from 30 November to 25 December is 25 more days, which gives 54. In the United States, Thanksgiving is the fourth Thursday in November, which is 26 November in 2026.

How to count the days yourself

There are two easy methods. The first is to count the days left in the current month and add the days up to the 25th of December. From 18 November, the month has 30 days, so 30 minus 18 leaves 12 days. Add 25 for December. The total is 37. The second is to use the day of the year. Christmas is the 359th day of a normal year, because the year has 365 days and 6 days follow the 25th. If today is the 322nd day of the year, which is 18 November, the difference is 359 minus 322, which equals 37. Both methods give the same answer, and the first is easier to do in your head.

Weeks until Christmas

To convert days into weeks, divide by 7. For 37 days, 37 divided by 7 is 5 with a remainder of 2, so 5 weeks and 2 days. Because Christmas 2026 is on a Friday, there are also 5 full Friday-to-Friday weeks if you count from the Friday 20 November, which is exactly 35 days earlier than 25 December. Weeks are a handy way to plan, since many people split a task list into weekly steps, such as finishing gift shopping by week 3 and wrapping by week 1.

Calendar days vs working days

A calendar day count includes weekends and holidays. If you need working days, for example to know how many days a delivery has, count only Monday to Friday. In 2026, 18 November is a Wednesday, so the weeks run in a regular pattern, and every full week contains 5 working days and 2 weekend days. In Excel, the NETWORKDAYS function does this for you, and you can pass a list of holidays to exclude, such as Thanksgiving. Working days matter for shipping deadlines, because carriers often do not deliver on Sundays or holidays, so a parcel sent on 20 December may not arrive by 25 December.

Excel formula that updates every day

To keep a live countdown in a cell, use =DATE(2026,12,25)-TODAY() and format the cell as a number. The result is 37 on 18 November 2026 and decreases by one each day. For text, use =DATE(2026,12,25)-TODAY()&" days until Christmas". To show weeks and days together, use =INT((DATE(2026,12,25)-TODAY())/7)&" weeks "&MOD(DATE(2026,12,25)-TODAY(),7)&" days". To make the formula work for any year, use =DATE(YEAR(TODAY()),12,25)-TODAY(), and add an IF to roll over to next year after Christmas: =IF(TODAY()>DATE(YEAR(TODAY()),12,25),DATE(YEAR(TODAY())+1,12,25),DATE(YEAR(TODAY()),12,25))-TODAY(). See our guides on DATEDIF and IF statements for more date formulas.

Plan backward from Christmas

Counting backward turns the countdown into a schedule. Start with 25 December and subtract the lead time for each task. If online orders need 10 days to arrive, order by 15 December, which is 10 days before Christmas. If you want to mail parcels abroad with a 14-day buffer, send them by 11 December. If you want to bake a fruit cake that matures for four weeks, start by 27 November, since 28 days before 25 December is 27 November. For a gift budget, divide the total by the number of weeks left, so that with 5 weeks to go and a budget of 500, you can spend 100 per week. This approach works for any event, such as a wedding or a product launch.

Sample Christmas planner with dates

Here is a simple plan you can copy into a spreadsheet. Finish the gift list by 20 November, which is 35 days before. Order online gifts by 1 December, 24 days before. Mail overseas parcels by 11 December, 14 days before. Buy fresh food and decorations by 20 December, 5 days before. Wrap everything by 23 December, 2 days before. In your sheet, put the due dates in one column and use =DATE(2026,12,25)-A2 in another to show the days before Christmas. Add a status drop-down, as in our drop-down list guide, and use our project tracker guide as a template for the full list.

Days until other dates

The method works for any date. Days until 1 December from 18 November is 13, and our days until December 1st calculator does that for you. Days until New Year, 1 January 2027, from 18 November is 44 days, since it is 7 days after Christmas. Days until the end of the year, 31 December, is 43. To count the days between any two dates, use our guide on DATEDIF in Excel, or simply subtract the dates in a spreadsheet and format the result as a number.

Why the number differs between sites

Different countdowns can show a different number for the same day for two reasons. Some count today, and some do not, which creates a difference of one day. Some count down to the start of 25 December at midnight, and some to the end of the day. A countdown that shows hours and minutes updates continuously, and the day number changes at midnight in your time zone. If you see 37 on one site and 38 on another, check the counting rule. In this guide, we count full calendar days between today and 25 December, not including today.

Countdown ideas for kids and classrooms

A visual countdown makes the wait more fun. A paper chain with 37 links, one removed each day, shows the days left from 18 November. An advent calendar starts on 1 December and has 24 doors, and it ends on Christmas Eve. In a classroom, you can turn the countdown into a math activity: ask students to calculate the days left, convert the days to weeks, and write the formula on the board. A simple sheet with a row for each date and a column for the days left lets children practice subtraction and see the pattern that the number drops by one each day. In a spreadsheet, a data bar on the days-left column shows the count shrinking as the date moves closer, which is a neat way to introduce conditional formatting to young learners.

Practice problems

Try these without looking at the table. Problem 1: how many days from 1 December to 25 December? The answer is 24. Problem 2: how many days from 10 November to 25 December? From 10 November to 30 November is 20, plus 25 is 45. Problem 3: how many weeks and days is 45 days? It is 6 weeks and 3 days. Problem 4: if you must mail a parcel 14 days before Christmas, what is the date? It is 11 December. Problem 5: write an Excel formula for the days left from today to 25 December 2026. The answer is the DATE minus TODAY formula above. Check each answer with a calendar.

Common mistakes

The most common mistake is to forget that November has 30 days, which shifts the total by one. Another is to count today when the source does not. A third is to ignore the weekday of Christmas, which affects how many working days you have. A fourth is to leave the year as a fixed number in an Excel formula, so the countdown breaks next year. A fifth is to plan shipping only by calendar days, without allowing for weekends and holiday closures. Add a buffer of a few days for anything that depends on a carrier.

Frequently asked questions

How many days until Christmas 2026?

On 18 November 2026 there are 37 days until Christmas Day on 25 December 2026.

What day of the week is Christmas in 2026?

Friday.

How many weeks until Christmas?

37 days is 5 weeks and 2 days from 18 November 2026.

How do I count the days until Christmas in Excel?

Use =DATE(2026,12,25)-TODAY().

Do the days include today?

This guide does not count today. Add one if your source counts it.

Related guides and free tools

Leave a Reply

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