No, I do not want it to only add 365 days (which is what DATE is doing). I want it to add however many days are in whichever years are being added on, accounting for leap years.

If Excel's DATE did this, 2 years on to 2011-01-25 would be 2013-01-26, but Excel gives 2013-01-15 because it is not adding that extra day for leap years. But I need it to and I don't understand why it doesn't.

For example: 2011-01-01
2011 has 365 days, so one year on to that date is: 2012-01-01
2012 has 366 days, so one additional year on to that date is: 2013-01-02
Excel's DATE, however, yields 2013-01-01 which is not correct.