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