ADDDATE() when the second argument is used (below 31) an interval can be added to a date.

Example

SELECT ADDDATE('2008-01-02',31)

Returns

2008-02-02