Thanks for letting me know it's not just me.

Don Guillett Wrote:
BTW when I answered this there were NO other replies.


--
Don Guillett
SalesAid Software

"Kevin Vaughn" wrote in
message
...
That's weird. I could have sworn when I looked at this question,
there
were
no replies. Then I replied and I see like 8 people have already
answered.
--
Kevin Vaughn


"Kevin Vaughn" wrote:

Try reversing the order of b1 and a1. In the test I tried, that's
how I
got
rid of the #num error.
Kevin Vaughn


"JohnH" wrote:

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



--
Kevin Vaughn
------------------------------------------------------------------------
Kevin Vaughn's Profile: http://www.excelforum.com/member.php...o&userid=34857
View this thread: http://www.excelforum.com/showthread...hreadid=551181