The ADDDAYS function adds or subtracts a specified number of days from a date. The input date can be in any supported date format. This function is commonly used to calculate deadlines, due dates, and future or past dates.
Syntax
ADDDAYS(date,value)
Arguments
date: The input date. This can also be a measure or reference.
value: The number of days to add or subtract. Use a positive value to add days and a negative value to subtract days.
