Year expiration date

Originally Posted by Kieran

Assume the intial date is in E8, then the formula is =DATE(YEAR(E8)+1,MONTH(E8),DAY(E8)).

Will automatically adjust for leap years.

if i put the formula in on the formula bar for h2 and I 2 its not working correctly.