Forum Discussion

roo4002's avatar
roo4002
Copper Contributor
Feb 10, 2023

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

 

excel
Formulas and Functions

1 Reply

  • mtarler's avatar
    mtarler
    Silver Contributor
    Feb 10, 2023
    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

Resources