months/days between two dates shown as a fraction

[Guest]

Can someone help with a formula to calculate the months between two dated shown as a fraction where the answer is 5 months and 10 days.

 

[Frank Kabel]

Hi
have a look at
http://www.cpearson.com/excel/datedif.htm

 

[Norman Harker]

Hi Alf!

To get months and days:

Where A1 contains the earliest date and B1 the latest date:

=DATEDIF(A1,B1,"m")&" months "&DATEDIF(A1,B1,"md")&" days"

For details of DATEDIF see:
Chip Pearson:
http://www.cpearson.com/excel/datedif.htm

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Guest]

Thanks Frank. However this does not get me an answer in fractions of a month ie, 7.333months etc. Can you help

Regard

Al

----- Frank Kabel wrote: ----

H
have a look a
http://www.cpearson.com/excel/datedif.ht

--
Regard
Frank Kabe
Frankfurt, German


Alf wrote

 

[Norman Harker]

Hi Alf!

First define how long a month is.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Frank Kabel]

Hi Alf
and how long is a month
30 days
31 days
365/12 days

 

[Guest]

Thanks very much Norman, this is the closest I get to solving my problem

Regard

Alf

 

[Norman Harker]

Hi Alf!

Thanks for thanks.

You need to be aware that you will get unusual answers where the
starting date is 31st of a month and ending date is 1st of a month
following a month with less than 31 days.

A less confusing approach would be to use weeks and fractions of weeks
because weeks have a constant length (unless they're holidays <vbg>)


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.