Want to know how many days are left until January 9th? Whether it’s a birthday, anniversary, or just a date you’re looking forward to, calculating the time remaining is a common question.
This article will show you how to manually figure out how many days until January 9th in future years, as well as how to use spreadsheet software to do the work for you.
How to calculate the days until January 9th
Want to know exactly how long you’ll be waiting? Here are a couple of methods for calculating the days until January 9th.
Manual Calculation
If you’re feeling old-school, you can calculate the number of days manually. Just count the days remaining in the current month and then add that to the number of days in each subsequent month until you get to January 9th.
Keep in mind, though, that you’ll need to remember that leap years have 366 days, not 365, and you’ll also need to know how many days are in each month. (Hint: “Thirty days hath September…”)
Using Spreadsheet Formulas
For a more precise answer, try a spreadsheet program like Google Sheets. Spreadsheet software will automatically calculate the number of days, cutting down on potential errors.
Here’s the Google Sheets formula for calculating the days remaining from today until January 9, 2026: =DATE(2026, 1, 9) - TODAY()
If you want to calculate the days remaining from a different starting date, just enter your start date in cell A1 and then use this formula: =DATE(2026, 1, 9) - A1
Important considerations for calculating dates
When you’re counting down the days, there are a few things to keep in mind:
- Time zones: January 9th arrives at different times depending on where you are.
- Holidays: These calculations only give you calendar days, not workdays. So, holidays aren’t subtracted.
- Leap years: 2026 isn’t a leap year, so February has 28 days.
- Daylight Saving Time: Daylight Saving Time isn’t observed on January 9th, 2026.
How many days until January 9, 2026?
Let’s say today is August 3, 2025. That means we still have a little while to wait!
From August 3, 2025, there are:
- 159 total days
- 114 weekdays
- 5 months and 6 days
- 22 weeks and 5 days
- 3,816 hours
…until January 9, 2026.
Conclusion
Whether you prefer to calculate manually or use a spreadsheet formula, there are several ways to track the days until January 9th.
Just remember to account for time zones and other factors to make sure your calculation is accurate.
However you do it, countdown tools can be a fun and useful way to anticipate an upcoming date.