Description of formula:
Returns a new DateTime that is a result of adding months to another date with time.
Returns a new DateTime that is a result of adding months to another date with time.
Syntax:
ADDMONTHS(date|datetime,number)
ADDMONTHS(date|datetime,number)
Parameters:
date(type:date)
A chosen date to which months can be added.
datetime(type: dateTime)
A chosen date with time to which months can be added.
number(type:Number)
A number of months. The months parameter can be negative or positive.
Returned type:
Date | DateTime
examples:
=addmonths(date(2026, 1, 1),1)
=addmonths(date(2026, 1, 1),1)
=addmonths(Section1.A1,14)
=addmonths(A,-1)
=addmonths(B3, C1+3)
=addmonths(datetime(2026,1,1,14,30,00),3)
=addmonths(datetime(C3),0.5)
0 Comments