Formula

[Ashish]

Please give me formula for automatic change date after one year,,

Ashish

 

[Bernard Liengme]

If you mean something like: A1 has a date and in B1 you want the date for
following year then
=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1))
best wishes