TodayFree forever - no sign-up, no paid plans

How to add months to a date

By Daniel Mercer · Updated November 21, 2026

Open the Months Between Dates Calculator

Adding days to a date is counting. Adding months to a date is navigation: you keep the day of the month, move the month forward, roll the year when you pass December, and deal with the one genuine hazard - a target month too short to hold your day. This guide gives the by-hand method, the spreadsheet formula, and the worked examples that cover every case, including the month-end clamp and the chained-addition trap that quietly moves renewal dates.

The by-hand method

Three steps. Step 1: add the number of months to the month of your date. Step 2: if the result passes December, subtract 12 for each year crossed and add those years to the year. Step 3: keep the same day of the month - unless the target month does not have that day, in which case clamp to its last day.

Examples cover the range. January 15, 2026 plus 3 months: month 1 + 3 = April, day stays 15 - April 15, 2026. December 15, 2026 plus 4 months: month 12 + 4 = 16, minus 12 is April, year becomes 2027 - April 15, 2027. August 31, 2026 plus 6 months: month 8 + 6 = 14, minus 12 is February 2027, and February 2027 has no 31st, so the day clamps to its last day - February 28, 2027. That third example is the whole reason this guide exists; everything else about adding months is bookkeeping. The reverse journey - counting the months between two dates once you have them - is covered in our guide on how to calculate months between two dates, and the date calculator on this site adds months and days together in one tool.

Learning how to add months to a date while working at a laptop

The spreadsheet method: EDATE

In Excel and Google Sheets, one function does all three steps: =EDATE(A1, 3) returns the date 3 months after the date in A1. Negative numbers go backwards: =EDATE(A1, -3). EDATE rolls the year, and it clamps - =EDATE(DATE(2026,1,31),1) returns February 28, 2026. Its defining virtue is that it always works from the date you hand it. =EDATE(DATE(2026,1,31),2) returns March 31, 2026, because the two-month jump is calculated from January 31 in one step and March has a 31st. Build any recurring schedule - renewals, payment dates, review dates - by adding increasing month counts to the one original start date (=EDATE(start, 1), =EDATE(start, 2), =EDATE(start, 3)...) and the schedule can never drift. Our Google Sheets guide shows EDATE doing the same work inside leftover-day formulas there.

The chained-addition trap

The one way to get adding months wrong is to chain it: add a month to the result of the last addition. From January 31, one chained step gives February 28 - correct so far - but the next step starts from the 28th and gives March 28, and by December the chain is sitting on the 28th, three days early, forever. Twelve chained steps from January 31 end on January 28; a single 12-month addition ends on January 31. Billing systems that compute each renewal from the previous renewal drift exactly this way, which is why a subscription started on the 31st so often renews on the 28th - the story is told in full in our guide on month-end dates. If a date matters, anchor it: store the original start date and the original day of the month, and compute every future date from those, never from the last date you produced.

Subtracting months

Subtraction is the same road in reverse, clamping included. March 31, 2026 minus 1 month is February 28, 2026 - there is no February 31 to land on going backwards either. October 31, 2026 minus 2 months is August 31, 2026, no clamp needed. January 15, 2027 minus 14 months: back 12 months to January 15, 2026, back 2 more to November 15, 2025. In a spreadsheet it is just a negative EDATE. The common use is working backwards from a deadline - a delivery date minus 3 months for a start date, a renewal minus 1 month for a cancellation deadline - and the counting rules for those notice-style periods are covered in our guide on how HR counts months in probation and notice. Once you have both dates, verify the gap with the months between dates calculator: enter the earlier date first and the count should return exactly the number of months you added or subtracted.

Adding months in bulk: payroll and billing runs

The anchor rule matters most when months are added hundreds of times at once. A payroll or billing system generating a year of dates from a single start date should compute each one from the original - start plus 1, start plus 2, start plus 3 - never from the previous row. Teams that generate the next date from the last one ship the drift described above into every February, and the error is usually discovered by a customer whose renewal landed three days early. One stored anchor date is the entire fix.

Frequently asked questions

How do I add months to a date by hand?

Add the months to the month number, carrying into the year whenever you pass December, and keep the same day of the month. December 15, 2026 plus 4 months: month 12 plus 4 is 16, which is April of the next year, giving April 15, 2027. If the target month has no such day - the 31st in a 30-day month, or anything above the 28th in February - clamp to the last day of the target month.

What is the Excel formula to add months to a date?

EDATE. =EDATE(A1,3) returns the date 3 months after the date in A1, and =EDATE(A1,-3) returns 3 months before. EDATE handles the year rollover and month-end clamping for you, and it always calculates from the date you give it, so =EDATE(A1,12) from January 31 gives January 31 of the next year. Google Sheets has the same function with the same behavior.

What happens when I add one month to January 31?

You get February 28 in a normal year and February 29 in a leap year. February has no 31st, so the result clamps to the last day of February. The date is still a full month later by the standard convention - it is the shortest full month there is - and adding further months from the original January 31 brings the 31st back in March.

How do I subtract months from a date?

Exactly the same method with the count reversed. By hand, subtract from the month number, borrowing a year when you pass January, and clamp the day if needed: March 31, 2026 minus 1 month is February 28, 2026. In Excel or Sheets, give EDATE a negative number: =EDATE(A1,-1). Subtraction clamps too, which surprises people at month-end going backwards as well as forwards.

Why did adding 1 month twelve times give a different date than adding 12 months once?

Because of chained clamping. Adding 1 month to January 31 gives February 28, and adding the next month to February 28 gives March 28 - the 31st is lost at the first step and never returns, so twelve chained steps end on January 28. A single 12-month addition from the original date gives January 31. Always add from the anchor date, not from the last result.

Related guides

Month-end dates - why January 31 plus one month is tricky

The clamp, the chain, and the systems that drift.

How to calculate months between dates in Google Sheets

EDATE at work inside Sheets formulas.

How to count months on a lease or contract

Adding months where the result is a legal end date.

How to convert months into years and days

Turning month counts into the other units.

Daniel Mercer

Daniel Mercer builds and maintains the calculators on this site. He spent ten years in payroll and operations roles counting business days, notice periods and deadlines by hand, and writes these guides the way he would explain the count to a colleague - the rule first, a worked example second, and the common mistake called out before it happens.