Days Until
Count the days until any date or upcoming event.
About Days Until
A simple countdown tool that tells you exactly how many days remain until any date you choose. Pick a preset event — such as Christmas, New Year, or a major holiday — or enter a fully custom date and name to create your own personal countdown.
How the countdown works
The calculator counts the number of whole days from today to your chosen date, using your device's local date so the result is always correct for your time zone. The count updates automatically each day without needing to refresh.
Preset events
- Christmas — 25 December
- New Year's Day — 1 January
- Halloween — 31 October
- Valentine's Day — 14 February
- Custom — any date you choose
Common uses
Counting down to holidays, birthdays, weddings, exams, travel dates, or product launches. The custom option makes it easy to track any personal milestone alongside the standard presets.
How date countdowns are calculated
A countdown to a future date is calculated by subtracting today's date from the target date in days. The result accounts for varying month lengths and leap years automatically. If the target date has already passed this year (like a birthday), the calculator advances to the next occurrence. Countdowns are useful for deadlines, events, renewals, and personal milestones.
- Fixed annual events — Christmas (25 Dec), New Year (1 Jan), tax deadlines
- Personal milestones — birthdays, anniversaries, retirement date
- Professional deadlines — contract end dates, renewal windows, visa expiry
- Project planning — sprints, launch dates, milestone tracking
Frequently Asked Questions
=A1-TODAY() to get the number of days remaining. Format the result as a number (not a date). Add =TEXT(A1-TODAY(),"0") to include it in a sentence like "Days remaining: X".