Adding years, months or days to a date

This will allow you to add years,months or days to a date in excel

Formula	Type
=DATE(YEAR(A2)+2,MONTH(A2),DAY(A2))	Years
=DATE(YEAR(A3),MONTH(A3)+5,DAY(A3))	Months
=DATE(YEAR(A4),MONTH(A4),DAY(A4)+6)	Days

As seen in print screen below