How to Count Days Until a Future Event
By The Editors, Encore Editorial, Updated June 21, 2026
To count days until a future event, enter today as the start date and the event date as the end date in a date calculator. The date calculator on this site returns the answer instantly. You can also use a spreadsheet formula that updates automatically every day you open it.
Why countdown dates matter
Countdowns serve real purposes beyond childhood impatience. A product launch in 47 days needs a detailed week-by-week workback plan. A visa that expires in 90 days requires immediate action. A subscription renewing in 3 days should prompt a cancellation decision today. "Days until" is one of the most practically useful date calculations there is.
The math is the same in all cases: subtract today from the future date and read the result. The only question is which tool to use and whether you need the count to update automatically.
Method 1: Use the date calculator
Open the date calculator, select "Days between dates," enter today as the start date, and enter the event date as the end date. The result is your countdown in days (and weeks and remaining days). This is the fastest method for a one-time lookup.
Method 2: Self-updating spreadsheet formula
This is the best method for tracking countdowns that you want to check regularly:
- In cell A1, type your event date (e.g., December 25, 2026).
- In cell B1, type
=A1-TODAY()
- Format B1 as a number (not a date).
Every time you open the spreadsheet, B1 shows the current number of days remaining. Add conditional formatting to turn the cell red when it drops below 14 days and you have a basic alert system.
For multiple events
Put event names in column A, event dates in column B, and in column C type =B1-TODAY() for each row. Sort by column C to see which deadline is closest. This turns any spreadsheet into a simple countdown dashboard.
How do you count days?
The official answer is: start at zero on today's date and increment by one for each day that passes until you reach the event. If today is June 21 and the event is July 5, the count goes: June 22 (1), June 23 (2), June 24 (3), June 25 (4), June 26 (5), June 27 (6), June 28 (7), June 29 (8), June 30 (9), July 1 (10), July 2 (11), July 3 (12), July 4 (13), July 5 (14). Result: 14 days remaining.
A date calculator does this automatically, which is why it exists.
Does the event day count?
Most date calculators, including the one on this site, use the exclusive convention: the end date is not counted. If today is June 21 and the event is June 22, the result is 1 day remaining. On the event day itself, the result is 0. This matches the way most people talk about countdowns: "the event is tomorrow, 1 day away" is correct even though both dates are only separated by a single night.
What date is 90 days from today?
From June 21, 2026, adding 90 days lands on September 19, 2026. The reverse question, "what date is today if the event is 90 days away?", subtracts 90 days from the event date using the subtract days from a date method.
Frequently asked questions
How do I count the days until a future event?
Enter today as the start date and the event date as the end date in the date calculator. The result is days remaining. In a spreadsheet, type =A1-TODAY() where A1 is the event date, formatted as a number.
How do you count days?
Start at zero on today's date and add one for each day that passes until you reach the target. A date calculator automates this and handles month lengths and leap years automatically.
What date is 90 days from today?
From June 21, 2026, 90 days forward is September 19, 2026. For any other starting date, use the date calculator.
Does the event day count in a days-until calculation?
No, not in standard date calculators. If today is June 21 and the event is June 22, the result is 1 day. On the event day, the result is 0.
How do I set up a self-updating countdown in a spreadsheet?
Put the event date in A1. In B1 type =A1-TODAY() and format B1 as a number. The count updates automatically every time you open the file.