AddMonths

Description of formula:
Returns a new DateTime that is a result of adding months to another date with time.
Syntax:
ADDMONTHS(date|datetime|utc, number)
Parameters:
date (Date)
A chosen date to which months can be added.
datetime (DateTime)
A chosen date with time to which months can be added.
utc (UTC)
A chosen date with time in UTC format to which months can be added.
number (Number)
A number of months. The months parameter can be negative or positive.
Returned type:
Date | DateTime | DateTime(UTC)
examples:
=addmonths(date(1999, 1, 1),1)
=addmonths(Section1.A1,14)
=addmonths(A,-1)
=addmonths(B3, C1+3)
=addmonths(datetime(1990,1,1,14,30),3)
=addmonths(UTC(2017,1,9,19,50),1.5)
=addmonths(datetime(C3),0.5)
Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk