How Many Days Until New Year? Countdown to January 1 With an Excel Formula
- Tahir Abbas
- November 18, 2026
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

