How calculate exact # of months between two dates?
Hi,
=DATEDIF(D5,E5,"y")&" years "&DATEDIF(D5,E5,"ym")&" months
"&DATEDIF(D5,E5,"md")&" days"
Change range to fit your needs
if this helps please click yes, thanks
"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!
|