How Many Days Until New Year? Countdown to January 1 With an Excel Formula

shape
shape
shape
shape
shape
shape
shape
shape
How Many Days Until New Year? Countdown to January 1 With an Excel Formula - featured image

New Year’s Day is January 1, and the last day of the year is New Year’s Eve on December 31. If today is November 18, 2026, there are 44 days until January 1, 2027, which is 6 weeks and 2 days. There are 43 days left in the year itself, because December 31 is one day before January 1. This page shows the countdown in days, weeks, hours and working days, lists the weekday of New Year’s Day for the next five years, explains how to count by hand and gives Excel formulas that update every day. You can use the same method for any other countdown, such as a birthday, a holiday or a project deadline.

Updated November 2026

In this guide

  1. The countdown from November 18, 2026
  2. Quick reference table
  3. Weekday of New Year’s Day
  4. How to count the days by hand
  5. Excel formula for the countdown
  6. Show weeks and days together
  7. Count working days until the end of the year
  8. Days between Christmas and New Year
  9. Make a countdown sheet
  10. Countdown for the end of the year in business
  11. Countdown to the exact hour
  12. Time zones and the exact moment
  13. Plan the last weeks of the year
  14. Common mistakes
  15. Practice problems
  16. Quick summary

The countdown from November 18, 2026

From November 18 to January 1 is 44 days. Here is how to see it. November has 30 days, so there are 12 days left after the 18th, which takes you to November 30. December has 31 days, and that brings the total to 43 days at December 31. One more day takes you to January 1, which makes 44. In weeks, 44 days is 6 weeks and 2 days, or 6.29 weeks. In hours, it is 44 times 24, which is 1,056 hours. In minutes, it is 1,056 times 60, which is 63,360.

Days Until December 1st Calculator screenshot used in the guide: How Many Days Until New Year? Countdown to January 1 With an Excel Formula
Check your answer with our free Days Until December 1st Calculator.

Quick reference table

These values are for November 18, 2026 and change by one each day.

UnitUntil January 1, 2027
Days44
Weeks and days6 weeks 2 days
Hours1,056
Minutes63,360
Days left in 202643

Weekday of New Year’s Day

January 1, 2027 falls on a Friday, and New Year’s Eve, December 31, 2026, is a Thursday. A regular year has 365 days, which is 52 weeks and 1 day, so New Year’s Day moves one weekday later each year. In a leap year, which has 366 days, it moves two weekdays. 2028 is a leap year, so the move from 2028 to 2029 is two weekdays, from Saturday to Monday. The other moves are one weekday each.

YearNew Year’s Day
2027Friday
2028Saturday
2029Monday
2030Tuesday
2031Wednesday

How to count the days by hand

Subtract the day of the year, which is the number of days since January 1. November 18 is day 322 of a normal year: the first ten months have 31, 28, 31, 30, 31, 30, 31, 31, 30 and 31 days, which add up to 304, and 304 plus 18 is 322. A normal year has 365 days, so there are 365 minus 322, which is 43 days left in the year, and one more to reach January 1, so 44. In a leap year, use 366 instead of 365 and add 1 to the days of the months after February.

Excel formula for the countdown

The simplest formula is =DATE(YEAR(TODAY())+1,1,1)-TODAY(). It builds January 1 of next year and subtracts today. On November 18, 2026 it returns 44. Format the cell as General or Number, because Excel may show a date. For the days left in the current year, use =DATE(YEAR(TODAY()),12,31)-TODAY(), which returns 43. If the target date is in cell B1, use =B1-TODAY(). The result changes every time the sheet is recalculated, so it is always current.

Show weeks and days together

To display 6 weeks 2 days, use =INT(A1/7)&" weeks "&MOD(A1,7)&" days", where A1 holds the countdown of 44. INT of 44 divided by 7 is 6, and MOD of 44 and 7 is 2. For hours, multiply by 24, which gives 1,056. You can also use DATEDIF to count full months and remaining days, as explained in our DATEDIF guide. A countdown with weeks is easier to read for a long period, and a countdown with days is better in the last weeks.

Count working days until the end of the year

Many people want to know how many working days remain. Use =NETWORKDAYS(TODAY(),DATE(YEAR(TODAY()),12,31)). This counts weekdays between the two dates, and it includes both ends. From November 18 to December 31, 2026, the result is 32 weekdays when no holidays are listed. If December 25, which is a Friday in 2026, is a holiday, add a holiday list as the third argument, and the result is 31. Use this to plan deadlines, leave and the last working day before the break.

Days between Christmas and New Year

The gap between December 25 and January 1 is 7 days, which is exactly one week. Many offices are closed or slow in this week, so it is useful for planning. In 2026 Christmas Day is a Friday and New Year’s Day is also a Friday. Check the countdown to Christmas on our days until Christmas page, and the Thanksgiving date on our Thanksgiving countdown. Together, the three pages cover the main dates of the holiday season.

Make a countdown sheet

Create a small table with the event names in column A, the dates in column B and the formula =B2-TODAY() in column C. Add rows for Thanksgiving, Christmas and New Year. Add conditional formatting so that a number below 10 turns red, and one below 30 turns orange. Use a custom number format such as 0 “days” to show the unit in the cell. Our days until December 1st calculator follows the same idea, and you can print the sheet or pin it on the wall for the family.

Countdown for the end of the year in business

Companies use the end-of-year countdown for deadlines, such as the last day to place an order, to close the books or to use up leave. If the financial year ends on December 31, then the number of days left tells you how much time remains for sales targets. For a quarter-end on December 31, a team with a target of 4,400 units and 44 days left needs to sell 100 units per day. This simple division turns the countdown into a daily goal that people can track.

Countdown to the exact hour

If you want a countdown that includes the time of day, use NOW instead of TODAY. NOW returns the date and the time. The formula =DATE(YEAR(NOW())+1,1,1)-NOW() returns a decimal number of days, such as 43.5 when it is noon. Multiply by 24 to get the hours, so 43.5 days is 1,044 hours. Format a cell with the custom format [h]:mm:ss to show the hours, minutes and seconds in a clock style. Excel only updates NOW when the sheet recalculates, which happens when you edit a cell or press F9, so it is not a live clock.

Time zones and the exact moment

The New Year begins at midnight local time, so it arrives at different moments around the world. A place far to the east, such as the Pacific islands, reaches January 1 many hours before a place in the Americas. The Excel formulas use the clock of your computer, so the countdown is for your own time zone. If you share a file with people in other countries, tell them that the countdown follows the local time on their computer, or add a time zone offset to the formula, such as plus 5 over 24 for a place five hours ahead.

Plan the last weeks of the year

A countdown is most useful when it turns into a plan. With 44 days left, you can split the time into three blocks: the first two weeks for finishing projects and reports, the next two weeks for holiday shopping and travel, and the last two weeks for celebrations and rest. Mark the key dates in your calendar, such as the last day for ordering gifts, the last working day and the day when offices reopen. A simple checklist beside the countdown keeps the plan visible and the stress low.

Common mistakes

The most common mistake is to count today as a full day, which makes the result one too high or one too low depending on the method. Another is to confuse December 31 with January 1, since there is one day between them. A third is to forget that Excel shows a date difference in date format until you change it to General. A fourth is to use a fixed year in the formula, so it breaks next year. Use YEAR(TODAY()) to keep it automatic. A fifth is to forget leap years when you count by hand.

Practice problems

Try these. Problem 1: how many days from December 1 to January 1? The answer is 31. Problem 2: how many days from November 30 to January 1? The answer is 32. Problem 3: if there are 44 days left, how many weeks is that? 6 weeks and 2 days. Problem 4: what weekday is January 1, 2028? Saturday. Problem 5: write an Excel formula that gives the days until the next New Year’s Day and test it today.

Quick summary

There are 44 days from November 18, 2026 to January 1, 2027, which is 6 weeks and 2 days or 1,056 hours. There are 43 days left in 2026, and 32 weekdays from November 18 to December 31 if no holiday is excluded. New Year’s Day 2027 falls on a Friday. In Excel, subtract TODAY from DATE of the next year, January 1, and format the result as a number. Use NETWORKDAYS for working days, and adapt the same formula for any other countdown you need.

Frequently asked questions

How many days until New Year 2027 from November 18, 2026?

There are 44 days.

What day is New Year’s Day 2027?

Friday.

How many days are left in the year?

On November 18, 2026 there are 43 days left in the year.

What is the Excel formula for days until New Year?

=DATE(YEAR(TODAY())+1,1,1)-TODAY()

How many working days are left in 2026?

From November 18 there are 32 weekdays, before removing holidays.

Related guides and free tools

Leave a Reply

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