Only if they are both in the same year.
--
David Biddulph

Rick Rothstein wrote:
Or, for inclusive months, maybe this...

=Month(B1)-Month(A1)


"JLatham" wrote in message
...
If you wanted the result to always be 3 (inclusive of all dates) you
can try:
=DATEDIF(DATE(YEAR(A1),MONTH(A1),1),DATE(YEAR(B1), MONTH(B1),1),"m")
That changes both dates to the first of both months used in the
DATEDIF() so
the 15th/16th problem doesn't come into play.
I actually tried using the EOMONTH() function, but that was still
susceptible to the variance depending on the end date of the months
involved.

"Rick Rothstein" wrote:

DATEDIF(StartDate,EndDate,"m") **may** be what you are looking for;
but then
again, it may not. You need to understand how it "counts" months in
order to
decide. Consider a start date of March 15, 2009 and an end date of
June 15,
2009... DATEDIF will report this as 3 months; **however**, change
the start
date to March 16, 2009 and DATEDIF now reports this as 2 months. It
appears
that DATEDIF counts full months starting its count from the starting
date.
Is that what you wanted?

--
Rick (MVP - Excel)


"Satyendra_Haldaur"
wrote in message
...
can anyone pls suggest that what is best way to calculate months
between
two
dates.