View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mark Livingstone Mark Livingstone is offline
external usenet poster
 
Posts: 4
Default How calculate exact # of months between two dates?

On Jul 21, 2:45*pm, Mike H wrote:
Hi,

Just a personal opinion but month is just about the daftest interval for
measuring time there is, is a month 28,29,30 or 31 days Hmm.

Anyway, I think this is what you want

=DATEDIF(A1,B1,"m")&"."&DATEDIF(A1,B1,"md")


The difference between 7/22/2009 and 8/21/2009 appears to be 0.30.
Odd.