Forum Discussion
DATEDIF returning 2/25/1900
My DateDif function is returning a date as opposed to the # of years im looking to calculate =DATEDIF(G2,TODAY(),"Y") this is the formula i am using
sounds like a cell format issue. go to home tab and change cell format to Number and adjust # of decimal places to 0 and you should get 56 in that case.
excel basically got it in its head that you are trying to put a date in that cell and you just have to tell it that it is a number not a date
excel basically got it in its head that you are trying to put a date in that cell and you just have to tell it that it is a number not a date