This function will add a specified number of days to a date.




ADDDAYS((x), y)




x = a date. This is the date you wish to use to add days to, preferred format of YYYY,MM,DD such as 2019, 8, 22 for 22nd of August 2019. This can also be the name of a date attribute.


y = the number, either positive or negative, of days you wish to add to the date (x)


Type of Data Returned


A date will be returned.




ADDDAYS((2019, 8, 22), 8) will return 30th of August 2019.


ADDDAYS((2019, 8, 22), 15) will return 6th of September 2019.


ADDDAYS((2019, 8, 22), -15) will return 7th of August 2019.