when i just set the equation in b column as =DATE(YEAR(A1)+1,MONTH(A1)-1,DAY(A1)-1)


but the date in a column is 01/02/2013 .after putting the equation the date comes in b column as 31/12/2014. actually it should come as 31/01/2014. how can i solve this