Adjusts the date by adding the year, month, and day values to the date provided. Note that any of the values for month, day, and year may be negative in value.

DATEADJUST(Date, Year, Month, Day)

Date: the system or derived date being adjusted.

Year: the number of years (positive or negative) by which the date is to be adjusted.

Month: number of months (positive or negative) by which the date is to be adjusted.

Day: number of days (positive or negative) by which the date is to be adjusted.

DATEADJUST(DATE(1,1,2015), 0, 6, 0) will return the internal system value the date 07/01/2015 (20150701).

DATEADJUST(DATE(1,1,2017), -1, -6, 5) will return the internal system value the date 07/06/2015 (20150706)