Hi Jessica

I forgot to say you need to format the cell with the formula as General.
Also, if you want it as a number and not text, then wrap the equation in
brackets and add 0

=(DATEDIF(A1,A2,"m")&MID(DATEDIF(A1,A2,"md")/DAY(EOMONTH(A2,0)),2,4))+0


Regards

Roger Govier


Roger Govier wrote:
Hi Jessica

One way, with start date in A1 and end date in A2
=DATEDIF(A1,A2,"m")&MID(DATEDIF(A1,A2,"md")/DAY(EOMONTH(A2,0)),2,4)

You need to load the addin Analysis ToolPak for this to work
ToolsAddins and check Analysis Toolpak

Regards

Roger Govier


Jessica wrote:

I am trying to find a function that will allow me to calculate the
difference between two dates. I want the answer to be shown in months
only, therefore I would need any additional days to be converted to a
decimal. I tried to the datedif function, but it does not recognize
that the time span between months may cross over multiple years.

For example I have the following:
Start Date: 04/15/02
End Date: 06/28/03

The number of whole months in between is 14, however their are also
additional days in between and I am looking to convert those to a
decimal.
I know the difference in months