AddMonths

Description of formula:
Returns a new DateTime that adds the specified number of months to the value of this instance.
Syntax:
ADDMONTHS(date, number)
Parameters:
date (Date)
-
number (Number)
A number of months. The months parameter can be negative or positive.
Returned type:
Date
examples:
=addmonths(date(1999, 1, 1),1)
=addmonths(Section1.A1,14)
=addmonths(A,-1)
=addmonths(B3, C1+3)
Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk