ADDYEARS
The ADDYEARS function allows you to add or subtract a specified number of years to a given date.
Syntax
Arguments
date - Date in any format. Required. This can also be a measure or a node reference.
value - Number of years to be added to the date. Required. Use a negative number to subtract the years from the given date.
Return Value
Date.
Example
![](https://docs.inforiver.com/~gitbook/image?url=https%3A%2F%2F3062809325-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FEbkCXCUXmtUq5tcnUtZE%252Fuploads%252FSyNIQIZRf75hDwDf4xEv%252Fimage.png%3Falt%3Dmedia%26token%3D36bdb2a8-73ea-4c5d-b807-f37cecb2ff67&width=768&dpr=4&quality=100&sign=d2c2c8f2&sv=1)
Last updated