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.
|