Hi I need calculate difference between two dates in Month & year
I am using below formula to calculate difference
DATEDIF(C5,H1,"y") & " years, " & DATEDIF(C5,H1,"ym") & " Months "
But I need to return in month & year. TEXT function return 1900 when its exceeding this year
The desired out put would be
29/10/2014 – Today = Oct 2014
But it gives me Oct 1900
I am using below formula to calculate difference
DATEDIF(C5,H1,"y") & " years, " & DATEDIF(C5,H1,"ym") & " Months "
But I need to return in month & year. TEXT function return 1900 when its exceeding this year
The desired out put would be
29/10/2014 – Today = Oct 2014
But it gives me Oct 1900