MONTH_ADD() : add months to a date

In a formula-type column, the MONTH_ADD() function displays a date obtained by adding a number of months to a date-type column. It is used to calculate monthly deadlines: subscription end date, next billing, contract renewal date.

Check the behavior at the end of the month. Adding months to a date near the end of the month (for example, January 31 + 1 month) can give a different result than expected, depending on the number of days in the following month.

Syntax

MONTH_ADD(date_column, number_of_months)

Parameters

# Parameter Description

1 date_column The date-type column to which months will be added.

2 number_of_months The integer number of months to add. Positive to move the date forward, negative to move it backward.

The output format of the column can be chosen in the output field options of the formula editor. For more details, see Output format options in the Formula Column article.

Examples

Add months to a date

MONTH_ADD($Date, 3)

The column returns the date shifted by 3 months.

Go further

MONTH_DELTA

Calculate the difference in months between two dates instead of adding to one.

Read more →

Or continue with

Formula glossary

All available operators and functions, sorted by category.