Adding and Calculating with Dates

If you want to find out what the date would be in X days/months/years time then this formula can help.

Where
A1 = 01/01/2012

=DATE(YEAR(A1),MONTH(A1),DAY(A1)+1) = 02/01/12
=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)) = 01/02/12
=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1)) = 01/01/13

Simply add in a cell reference for the days/months/years to add and this is a very powerful formula