How to add or subtract X amount of days/months/years from a date.
Use either of the follow methods:
DATE(DateField, MMDDYY) + XX days (for addition)
DATE(DateField, MMDDYY) - XX days (for subtraction)
Replace "days" with "months" or "years" as needed.
DAYS(Date(DateField, MMDDYY)) - XX
DAYS(Date(DateField, MMDDYY)) + XX
To do the calculation and then convert the answer back to a date, the equation would be as follows:
DATE(DAYS(Date(DateField, MMDDYY)) - XX)
Note: No date wrapper is used to convert the DAYS to a DATE
For calculations involving CURDTE(), the equation would be similar to the following:
DATE(DAYS(CURDTE()) - XX)
Note: CURDTE() and ISO dates do not need a date wrapper
Still have questions? We can help. Submit a case to Technical Support.