Connect via MCP →

Enter Calculation

Formula

Formula: Date ± Calendar Units Calculator
Show calculation steps (1)
  1. Month / quarter / year stepping

    Month / quarter / year stepping: Date ± Calendar Units Calculator

    For months, quarters and years the calculator steps whole calendar months and clamps the day to the last valid day of the target month.

Advertisement

Results

< style> .main-result { background:#e3f2fd; border:2px solid #2196F3; border-radius:6px; padding:1.5rem; margin-bottom:1rem; text-align:center; } .main-result-label { font-size:1.1rem; color:#1565C0; margin-bottom:0.5rem; } .main-result-value { font-size:2rem; font-weight:800; color:#0D47A1; line-height:1.2; } .main-result-unit { font-size:1.05rem; color:#1976D2; margin-top:0.5rem; } .result-table { width:100%; border-collapse:collapse; margin-top:1rem; } .result-table th, .result-table td { padding:0.5rem 0.6rem; text-align:left; border-bottom:1px solid #ddd; font-size:0.95rem; } .result-table th { background:#f5f5f5; font-weight:600; width:45%; }
Monday June 15, 2026 plus 180 days is
Saturday December 12, 2026
12/12/2026 · 346th Day of 2026
Result date 12/12/2026
Result weekday Saturday
Result day of year 346th Day of 2026
Start date Monday June 15, 2026
Start day of year 166th Day of 2026

What this calculator does

The Date plus or minus Calendar Units Calculator adds or subtracts a chosen number of days, weeks, months, quarters, or years to or from any starting date. It returns the resulting calendar date in your preferred format, the weekday, and the day-of-year for both the start and result dates. It uses the proleptic Gregorian calendar, so it works the same everywhere with no national holiday or business-day rules.

How to use it

Enter the starting date (year, month, day), pick a Date Format (USA m/d/yyyy, Europe d-m-yyyy, or ISO yyyy-mm-dd) that controls how dates are displayed, choose the Operator (add or subtract), type the number of Units, and select the Unit Type. The number may be zero or negative.

The formula explained

Days and weeks use exact day counting: the date is turned into a Julian Day Number (JDN), the signed offset is added (weeks are multiplied by 7), and the JDN is converted back, automatically respecting 365- and 366-day years. The general relationship is $$\text{Result} = \text{Start Date} \;\pm\; n \times \text{Unit}$$ For days and weeks this becomes $$\text{JDN}_{result} = \text{JDN}_{start} + n_{days}$$ Months, quarters, and years step whole calendar months. The total months are computed, divided into a year and month, and the day is clamped to the last valid day of that month: $$D_{result} = \min\big(D_{start},\; \text{daysInMonth}(Y_{result}, M_{result})\big)$$ For example, January 31 minus one month becomes the last day of the previous month, not an overflow into the next one.

Timeline showing a start date with subtraction to the left and addition to the right using calendar units
Adding or subtracting calendar units moves the start date forward or backward along the timeline.

Worked example

Start 6/15/2026 (a Monday, the 166th day of 2026), add 180 days. The Julian Day Number is 2461577; adding 180 gives \(2461577 + 180 = 2461757\), which is December 12, 2026 - a Saturday and the 346th day of 2026. So the result reads "Saturday December 12, 2026 / 12/12/2026 / 346th Day of 2026".

Two calendars connected by an arrow showing the start date shifting to a result date in a later month
A worked example: shifting the start date by several units lands on a new calendar date and weekday.

FAQ

Why does adding a month sometimes change the day? Because months have different lengths. Adding a month to January 31 lands on the last valid day of the next month (February 28 or 29) by clamping.

How are leap years handled? Day and week arithmetic counts real days, so leap days are crossed correctly. Adding whole years to February 29 lands on February 28 in non-leap target years.

Does it count business days? No - it works in pure calendar units and ignores weekends and holidays.

Last updated: