ThisCalculator

Date and time

Date Calculator: Add and Subtract Days

Updated · Standard formula, shown below

The calculator for this page is switched off while it is checked. The formula is below, and the worked example in the article shows how to use it by hand.

Date Calculator: Add and Subtract Days

A date calculator for adding and subtracting days takes a start date, applies a number of days (positive or negative), and returns the resulting calendar date. You enter the start date and the number of days to add or subtract, and the calculator outputs the new date, often along with the day of the week.

Formula

The calculation is straightforward: Result date = Start date + N days, where N is the number of days to add (if positive) or subtract (if negative). The formula works by converting the start date to a serial day number (the number of days since a fixed epoch, such as January 1, 1900), adding N to that number, and converting the result back to a calendar date. The unit of N is days, and the result is a date in the same calendar (Gregorian).

Worked Example

Using the default values: start date = 2025-01-15, days to add = 90.

  1. Convert 2025-01-15 to a serial day number. (For reference, 2025-01-15 is day 45672 in the Excel-style serial system.)
  2. Add 90 days: 45672 + 90 = 45762.
  3. Convert 45762 back to a calendar date. 45762 corresponds to 2025-04-15.

The result is 2025-04-15. The calculator displays the same result when you use the defaults.

Why Add or Subtract Days?

Adding or subtracting days is one of the most common date operations in daily life and business. People use it to:

  • Calculate due dates for invoices, payments, or project milestones.
  • Determine a delivery date (e.g., “arrives in 5 business daysâ€� – though that usually excludes weekends).
  • Find a date 90 days from today for visa or travel rules.
  • Compute expiration dates for coupons, warranties, or subscriptions.
  • Plan personal events like a birthday 30 days from now.

The operation is simple, but doing it mentally can be error-prone, especially across month boundaries and leap years.

How Date Arithmetic Works

Behind the scenes, date calculators use a serial day number system. The most common is the Excel serial date, where January 1, 1900 is day 1. Another is the Unix epoch (January 1, 1970), but that counts seconds, not days. For adding days, the exact epoch doesn’t matter as long as the conversion is consistent.

When you add 30 days to January 15, the calculator doesn’t just add 30 to the day-of-month (which would give 45). Instead, it advances through the calendar: January has 31 days, so 15 + 30 = 45, which is 14 days into February (since 45 – 31 = 14). So the result is February 14. The calculator handles month lengths automatically, including February’s 28 or 29 days.

Common Mistakes and Pitfalls

Even with a calculator, users often make mistakes when they try to do it manually or misinterpret the result:

  • Month boundaries: Adding 30 days to January 31 gives February 30 in a naive calculation, but February never has 30 days. The correct result is March 2 (or March 1 in a non-leap year, depending on how you count). A calculator avoids this by using serial days.
  • Leap years: Adding 365 days to February 29, 2024 (a leap year) gives February 28, 2025, not February 29, because 2025 is not a leap year. The calculator accounts for this.
  • Negative numbers: Subtracting days is the same as adding a negative number. For example, subtracting 45 days from March 1, 2025 gives January 15, 2025. Ensure you enter the negative sign correctly.
  • Time of day: If you enter a date with a time component (e.g., 2025-01-15 14:30), adding days preserves the time. But most simple date calculators ignore time and work with dates only.
  • Business days vs. calendar days: This calculator adds calendar days. If you need “5 business days,â€� you must exclude weekends and holidays, which requires a more complex calculation.

How to Choose a Date Calculator

Not all date calculators are the same. When choosing one, consider:

  • Does it handle negative days? Some calculators only allow positive numbers. For subtracting, you need one that accepts a minus sign.
  • Does it show the day of the week? Useful for planning, but not essential.
  • Does it support business days? If you need to skip weekends, look for a business-day calculator. This page only does calendar days.
  • Does it handle dates before 1900? Some systems (like Excel) have limitations for very early dates. For most practical use, 1900 is fine.

For most purposes, a simple add/subtract calculator like the one above is sufficient. If you need to count days between two dates, you’d use a different tool.

Real-World Applications and Examples

Here are a few concrete scenarios where adding or subtracting days is useful:

  • Project deadline: A project starts on March 10 and lasts 45 days. The end date is April 24 (March has 31 days, so 10 + 45 = 55, minus 31 = 24).
  • Visa 90-day rule: You enter a country on June 1. You must leave within 90 days. The last day is August 30 (June has 30 days, July has 31, so 30+31+30 = 91, so you have until August 29 if counting inclusively – check local rules).
  • Warranty: A product is purchased on November 15 with a 1-year warranty. The warranty ends on November 15 of the next year, regardless of leap years.
  • Subscription trial: A 14-day free trial starts on February 20. It ends on March 6 (February has 28 days in a non-leap year, so 20+14 = 34, minus 28 = 6).

These examples show how the calculator handles month lengths automatically.

Limitations of the Formula

The simple formula works for the Gregorian calendar, which is the standard in most of the world. It does not account for:

  • Business days: It counts every day, including weekends and holidays.
  • Time zones: If you cross time zones, the “dayâ€� may shift. For date-only calculations, this is usually irrelevant.
  • Historical calendar changes: Some countries switched from the Julian to the Gregorian calendar at different times. This calculator assumes the modern Gregorian calendar for all dates.
  • Date ranges beyond 9999: Most systems cap at year 9999.

For everyday use, these limitations rarely matter.

Frequently Asked Questions

How do I subtract days using a date calculator?

Enter the start date and then enter a negative number in the days field. For example, to find the date 30 days before March 15, enter 2025-03-15 as the start date and -30 as the days. The result will be February 13, 2025.

What is the difference between calendar days and business days?

Calendar days include every day of the week, including Saturdays, Sundays, and holidays. Business days typically exclude weekends (and sometimes holidays), so they are only Monday through Friday. This calculator works with calendar days only.

Does the calculator account for leap years?

Yes. The calculator uses the actual number of days in each month, which includes February 29 in leap years. For example, adding 365 days to February 29, 2024 gives February 28, 2025, not February 29.

Can I add months or years instead of days?

This calculator only adds or subtracts days. For months or years, you would need a different tool, because month and year lengths vary. Adding a month to January 31 is ambiguous – some calculators give February 28, others March 2.

Why does adding 30 days to January 31 give March 2, not February 30?

Because February never has 30 days. The calculator advances through the calendar: January has 31 days, so 31 + 30 = 61 days from January 1. January 1 + 61 days = March 2 (31 days in January + 29 days in February in a leap year = 60, so one more day into March).

What if I enter a date before 1900?

Most date calculators, including this one, handle dates before 1900 correctly using the Gregorian calendar. However, some software (like Excel) has a known bug with dates before 1900. If you need pre-1900 dates, verify the calculator’s documentation.

Related

Formula used
in start | Start date (YYYY-MM-DD) | - | 2025-01-15 | 0
in days | Days to add (+) or subtract (-) | days | 90 | 0
out result | Result date | - | start + days | 0

Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.