Please give me formula for automatic change date after one year,, Ashish
B Bernard Liengme Jan 7, 2010 #2 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
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
