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
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.
Or continue with
Formula glossary
All available operators and functions, sorted by category.