ADDDATE() when the second argument is used (below 31) an interval can be added to a date.
SELECT ADDDATE('2008-01-02',31)
2008-02-02