AddYears

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

0 Comments

Article is closed for comments.
Powered by Zendesk