# ADDYEARS

The ADDYEARS function allows you to add or subtract a specified number of years to a given date.

### Syntax <a href="#syntax" id="syntax"></a>

```java
ADDYEARS(date,value)
//adds the given number of years to the date and returns it
```

### Arguments <a href="#arguments" id="arguments"></a>

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 <a href="#return-value" id="return-value"></a>

Date.

### Example <a href="#example" id="example"></a>

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FSyNIQIZRf75hDwDf4xEv%2Fimage.png?alt=media&#x26;token=36bdb2a8-73ea-4c5d-b807-f37cecb2ff67" alt=""><figcaption><p>ADDYEARS</p></figcaption></figure>
