How to calculate "number of months" between two given date?
On Thu, 13 Apr 2006 16:23:24 -0500, Carim
wrote:
Hi,
=DATEDIF(A2,B2,"m")+(DAY(A2)DAY(B2))+1
HTH
Cheers
Carim
Start date 28-Feb-2006
End date 2-Mar-2007
Your formula -- 14
OP wants -- 13
Start date 28-Feb-2006
End date 2-Mar-2006
Your formula --2
OP wants -- 1
--ron
|