Adds a specific number of days to a date. Use a negative number of days to count backwards.
Syntax
add_days(date, number-of-days)
Learn more about syntax for functions.
Parameters
- date: A Date, or a function that returns a date.
- number-of-days: An integer that specifies the number of days to add or remove from date. Use a negative integer to count backwards.
Examples
-
add_days(today(), 7): If today is October 24, 2016, the function returns October 31, 2016. -
add_days(date(2016,10,31), -7): Returns October 24, 2016.