Adds a specific number of days to a date. Use a negative number of days to count backwards. 


add_days(date, number-of-days)
Learn more about syntax for functions.


  • 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.


  • 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.

Was this helpful?
How can we improve it?