View Single Post
  #15   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld
 
Posts: n/a
Default 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