Hi John, datedif calculates de difference of the two dates, but the formula
must be

DATEDIF(INITIAL DATE,LAST DATE,TYPE OF DIF)

Try to put Datedif(a1,ba,"m")

hope this helps
regards from Brazil
Marcelo

"JohnH" escreveu:

I'm using Excel 2000 and trying to use the datedif function. I've formated 2
columns as date m/dd/yyyy and left the formula column general I'm entering
dates
A1: 1/1/2002
B1: 1/1/2005

I'm entering the formula in C1
=datedif(b1,a1,"M")

I'm looking for the nmber of months between 2 dates

I get #NUM! for a result.

Thanks
John