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")
For help look here
http://www.cpearson.com/excel/datedif.htm
Mike
"Mark Livingstone" wrote:
Hi,
Right now I am using the DATEDIF(CELL1, CELL2, "m") function. However,
it provides only single digit response. So, if the two dates are 20
JUNE and 20 SEPTEMBER, it will be 2 months. However, if the two dates
are 20 JUNE and 20 SEPTEMBER, it give me 1 month instead of 1 month
and X days (or, 1.x << this is exactly output that I am trying to
achieve)
Any idea how to do that? Excel 2003.
Thanks!