0
I'm trying to calculate the age of my credit card accounts in Excel. I've read online to use the DATEDIF() function, however, I'm not getting the expected result and I'm not sure where I screwed up.
The formula entered is =DATEDIF(C2,TODAY(),"m")
The contents of C2 are =DATE(2010,6,8)
For some reason it's returning some random day in 1900 instead of the months since opening. Any help is appreciated.