How do I add months to a date in Excel?

The built-in way is EDATE(date, months). Tellsheet's Date Calculator does it across a whole column at once and clamps to the end of short months, so January 31 plus one month lands on February 28.

Can it add business days and skip weekends?

Yes. Choose the Business days unit and it moves forward or backward counting only Monday to Friday, the same idea as WORKDAY, applied to the whole column.

Is the result still a real Excel date?

Yes. Only genuine date cells are shifted, and the output stays a real Excel date you can sort, filter, and compute on — it is not turned into text. Text cells are left alone.

Home › Excel Guides › Add or Subtract Dates

How to Add or Subtract Days, Months, or Years from Dates in Excel

Days are easy — you just add a number. Months, years, and business days each need a different function, and month math has a trap at the end of short months. Here's what breaks, and the one-click way that gets every unit right.

Last updated: August 2026

Date		Result
2026-03-01	→	2026-03-31 (+30 days)
2026-01-31	→	2026-02-28 (+1 month, clamped)
2026-06-12 (Fri)	→	2026-06-17 (+3 business days)

Why the built-in way gets fiddly

Adding days is simply =A2+30. But months need =EDATE(A2,1), years need =EDATE(A2,12), and business days need =WORKDAY(A2,3) — a different function for each unit, and each has to be copied down the whole column. The nastiest bit is month-end: adding a month to January 31 should give February 28, not an invalid date. A day-count fudge like +30 quietly gets it wrong, and mixing units in one pass means juggling several formulas at once.

The 1-click way — Tellsheet's Date Calculator

Select the column of dates and run Date Calculator. Choose Add or Subtract, type a number, and pick a unit — days, weeks, months, years, or business days (weekends skipped). Month and year math is calendar-correct and clamps to the end of short months (Jan 31 + 1 month → Feb 28). Only real date cells are shifted; your header row and any text are left untouched, and the result stays a real Excel date. Pairs with Convert Text to Date and Timezone Converter.

Frequently asked questions

How do I add months to a date?

Pick the Months unit. It works like EDATE across the whole column and clamps to the last day of short months, so Jan 31 + 1 month is Feb 28.

Can it skip weekends?

Yes — choose Business days and it counts only Monday to Friday, forward or backward, like WORKDAY.

Does it change my header row?

No. Leave "First row is a header" on and the header stays put; only the data dates move.

Is the answer a real date or text?

A real Excel date — you can sort, filter, and calculate on it. Non-date cells in the column are left alone.

Related Excel guides

Shift a column of dates in one click

Date Calculator adds or subtracts days, months, years, or business days across a whole column — month-end clamped, and the result stays a real Excel date.

Get Tellsheet free See pricing