P
prejithapillai
when i just set the equation in b column a
=DATE(YEAR(A1)+1,MONTH(A1)-1,DAY(A1)-1
but the date in a column is 01/02/2013 .after putting the equation th
date comes in b column as 31/12/2014. actually it should come a
31/01/2014. how can i solve thi
=DATE(YEAR(A1)+1,MONTH(A1)-1,DAY(A1)-1
but the date in a column is 01/02/2013 .after putting the equation th
date comes in b column as 31/12/2014. actually it should come a
31/01/2014. how can i solve thi