DATE + NUMBER (of) MONTHS (+ Operator)
The DATE + MONTHS operator calculates a new date value by adding the number of months to a DATE you specify.
The DATE + MONTHS operator works with a date value, which can be a date expression, a Date variable, or the result of a function that returns a date. The number of months to be added can be a number value, which can be a number expression, a Number variable, or the result of a function that returns a number.
Operator | Description | After you drag and drop the operator into the script tab: | Expression returns: |
DATE + NUMBER (of) MONTHS | ⟦Date⟧ + ⟦Number⟧ MONTHS | Replace ⟦DATE⟧ placeholder with the date value you want to add to. Replace ⟦Number⟧ placeholder with the number value you want to add. | A DATE value. |
Example
DATE OF(31, 1, 2020) + 3 MONTHS // Results in the date value 4/31/2020