Description of formula:
Returns a new DateTime that is a result of adding years to another date with time.
Returns a new DateTime that is a result of adding years to another date with time.
Syntax:
ADDYEARS(date|datetime, number)
ADDYEARS(date|datetime, number)
Parameters:
date(type:date)
A chosen date to which years can be added.
datetime(type: datetime)A chosen date with time to which years can be added.
number(type:number)
A number of years. Parameter value can be negative or positive.
Returned type:
Date|Datetime
examples:
=addyears(date(1999, 1, 1),1)
=addyears(Section1.A1,14)=addyears(date(1999, 1, 1),1)
=addyears(A,-1)
=addyears(B3, C1+3)
=addyears(datetime(2016, 1, 1,12,15,00),1)
=addyears(UTC(A1),3)
0 Comments