Find out exactly how many days, weeks, and months remain until any future date. Count down to holidays, birthdays, deadlines, and events instantly.
✓Verified: April 2026
Please enter a valid future date.
Enter any upcoming date to count down to
Leave blank to count from today
📅 Today is:—
Days Remaining
—
Was this calculator helpful?
✓ Thanks for your feedback!
How It Works
✓
Date countdown uses ISO 8601 Gregorian calendar arithmetic. Leap years and month lengths are handled automatically by JavaScript’s native Date object.
Reference for elapsed and remaining day calculations, week breakdowns, and leap year treatment
Methodology: Days Until = Future Date − Start Date (in milliseconds ÷ 86,400,000, rounded up with Math.ceil). Weeks = Days ÷ 7 (rounded down) with remainder days. Approximate months = Days ÷ 30.4375 (average Gregorian month including leap year frequency). Exact years and months counted by iterating calendar periods. All leap year handling is automatic via the JavaScript Date object.
⏱ Last reviewed: April 2026
How to Calculate Days Until a Future Date
Counting the days remaining until an upcoming event is one of the most useful time calculations in everyday life. Whether you’re counting down to a holiday, tracking a project deadline, planning a trip, or simply wondering how long until your birthday, the formula is straightforward. The challenge is correctly handling months of different lengths and leap years — which this calculator handles automatically.
The Days Until Formula
Days Until = Future Date − Today’s Date
Example: Today is April 6, 2026 and the target date is December 25, 2026.
Days Until = December 25, 2026 − April 6, 2026 = 263 days
Weeks = 263 ÷ 7 = 37 weeks, 4 days
Months ≈ 263 ÷ 30.44 = approximately 8.6 months
Days Until vs. Days Since
Days until counts from today forward to a future date — the result is how many days remain. Days since counts backward from today to a past date — the result is how many days have elapsed. Use days until for countdowns and deadline planning. Use days since for tracking progress and elapsed time. Both share the same underlying subtraction formula; only the direction changes.
How Leap Years Affect the Count
A leap year adds February 29 to the calendar, making that year 366 days instead of 365. When your countdown spans February 29 of a leap year, the total day count increases by one. For example, counting days from April 6, 2026 to April 6, 2028 gives 731 days rather than 730, because 2028 is a leap year. This calculator accounts for leap years automatically — no manual adjustment needed.
Major 2026 Countdown Reference Table
Event
Date
Days from April 6, 2026
Mother’s Day 2026
May 10, 2026
34
Memorial Day 2026
May 25, 2026
49
Independence Day 2026
July 4, 2026
89
Labor Day 2026
September 7, 2026
154
Halloween 2026
October 31, 2026
208
Thanksgiving 2026
November 26, 2026
234
Christmas 2026
December 25, 2026
263
New Year’s Day 2027
January 1, 2027
270
Days Until in Excel and Google Sheets
In Excel or Google Sheets, calculating the days remaining until a future date uses a simple formula. If your future date is in cell A1, enter =A1-TODAY() and format the result cell as a number (not a date). This gives the exact day count from today. To get weeks, use =INT((A1-TODAY())/7). Google Sheets uses identical formulas. For automatic updates, these formulas recalculate every time the sheet is opened, just like this calculator refreshes to the current date each visit.
Common Uses for a Days Until Calculator
Holiday countdowns — days until Christmas, Thanksgiving, New Year, or other holidays
Birthday countdown — how many days until your or someone else’s birthday
Deadline tracking — days until a project due date, exam, or submission deadline
Trip planning — days until a vacation, flight, or event begins
Contract and legal deadlines — days remaining in a warranty, lease, or agreement period
Retirement planning — days until retirement or a financial goal date
Sports and events — days until a game, concert, or special occasion
Wedding and anniversary countdown — days until a major life event
💡 Inclusive vs. exclusive counting: This calculator uses exclusive counting by default — it counts the days between today and the future date, not including today. If you want to include today as “Day 1,” add 1 to the result. For most deadline and countdown purposes, the exclusive count is standard (the same method courts use for filing deadlines and banks use for maturity dates).
Days Until in Programming
In JavaScript: Math.ceil((new Date(futureDate) - Date.now()) / 86400000). In Python: (future_date - date.today()).days. In SQL (MySQL): DATEDIFF(future_date, CURDATE()). In PHP: (new DateTime($futureDate))->diff(new DateTime('today'))->days. All return the same result as this calculator for any valid future date in the Gregorian calendar system.
Frequently Asked Questions
Subtract today from the future date. Days Until = Future Date − Today. For example, April 6, 2026 to December 25, 2026 is 263 days. This calculator handles the subtraction automatically, including leap years and month length differences.
From April 6, 2026, there are 263 days until December 25, 2026. Enter December 25, 2026 in the calculator above to get the exact countdown updated to today’s date automatically every time you visit.
From April 6, 2026, there are 270 days until January 1, 2027. Click the “New Year 2027” quick button above or enter January 1, 2027 manually to see the current countdown.
Days Until = Future Date − Today’s Date. In JavaScript: Math.ceil((futureDate - Date.now()) / 86400000). In Python: (future_date - date.today()).days. In Excel: =A1-TODAY() where A1 contains the future date, formatted as a number.
Enter your next birthday date in the calculator to find the exact countdown in days, weeks, and months. If your birthday has already passed this year, enter next year’s date. The calculator updates automatically to today’s date on each visit.
Yes. To include today as Day 1, add 1 to the result. If 30 days remain until an event, the inclusive count is 31. The calculator shows the exclusive count by default, which is standard for deadline tracking — the same method used by courts for filing deadlines and banks for loan maturity dates.
In Excel, use =A1-TODAY() where A1 contains your future date. Format the result as a number. To get weeks use =INT((A1-TODAY())/7). Google Sheets uses identical formulas. Both automatically update to the current date each time the file is opened, so the countdown stays accurate without manual updates.
Divide the days remaining by 7. Weeks Until = Days Until ÷ 7 (rounded down). If 63 days remain, that is exactly 9 weeks. If 70 days remain, that is 10 weeks exactly. The calculator shows week and remaining day breakdowns automatically in its results.
Days until counts forward from today to a future date, giving days remaining. Days since counts backward from today to a past date, measuring elapsed time. Use days until for countdowns and planning. Use days since for tracking how long something has been in progress. Both use the same subtraction formula — only the direction differs.
From April 6, 2026, there are 208 days until October 31, 2026. Click the Halloween quick button above, or enter October 31, 2026 to get the exact count updated to today’s date.
Yes. Leap years are handled automatically. When your countdown range includes February 29 of a leap year, that extra day is counted. For example, counting days from April 6, 2026 to April 6, 2028 gives 731 days, not 730, because 2028 is a leap year with February 29.
This calculator counts calendar days, which include weekends and public holidays. For business day countdowns only, divide the calendar day result by approximately 1.4 as a rough estimate, or use a dedicated business day calculator. Calendar days are the standard for most personal countdown purposes like birthdays and holidays.
Use this Days Until Calculator directly in your mobile browser — it is fully optimized for phones and tablets. On iPhone, you can also ask Siri: “How many days until December 25?” On Android, Google Assistant responds to the same question. This calculator gives more detail, including the week and month breakdown.