DATEDIF does not work in excell2007

[avsLX]

I am trying to calculate the age difference in months between 2 specific dates using the =DATEDIF(A1,B1,"m") formula, but i get a #NUM error eveytime... Both the date cells are formated as date, and the first one inserted is before the second...

[alansidman]

Seems like you have done it correctly. Without actually seeing your worksheet, a diagnosis is nearly impossible. Suggest you upload your worksheet. Be sure to sanitize it for confidential information.

[gmr4evr1]

Is the date in B1 lower than the date in A1? If so, this could be the cause of the #NUM! error.

EDIT* I just noticed what this line probably means..

the first one inserted is before the second...

so my statement above would not be relevant.

[daddylonglegs]

That seems like it should work

Check if the dates are actually numeric with this formula

=COUNT(A1,B1)

what result do you get?

[avsLX]

Thank you all for your help.
Somehow I got it to work with =DATEDIF(A1;B1;"M")