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
- The quick answer for 2026
- Countdown table: days left on key dates
- How to count the days yourself
- Weeks until Christmas
- Calendar days vs working days
- Excel formula that updates every day
- Plan backward from Christmas
- Sample Christmas planner with dates
- Days until other dates
- Why the number differs between sites
- Countdown ideas for kids and classrooms
- Practice problems
- 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.

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.
| Date | Days until Christmas | Weeks and days |
|---|---|---|
| 1 November | 54 | 7 weeks 5 days |
| 15 November | 40 | 5 weeks 5 days |
| 18 November | 37 | 5 weeks 2 days |
| 26 November (Thanksgiving) | 29 | 4 weeks 1 day |
| 27 November (Black Friday) | 28 | 4 weeks |
| 30 November (Cyber Monday) | 25 | 3 weeks 4 days |
| 1 December | 24 | 3 weeks 3 days |
| 10 December | 15 | 2 weeks 1 day |
| 15 December | 10 | 1 week 3 days |
| 20 December | 5 | 5 days |
| 24 December | 1 | 1 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.


