Abstract

If you need the number of full months or the total count of days between two days you can use DATEDIF. Easy so far. But what if you need the number of months in fractions?

This way it is done correctly:

Fractions_of_Months_Example

Note: If you use the EOMONTH function you can abbreviate the formula to

=DATEDIF(A2,B2,"m")+IF(DAY(B2)>=DAY(A2),(DAY(B2)-DAY(A2))/DAY(EOMONTH(B2,0)),(DAY(EOMONTH(A2,0))-DAY(A2))/DAY(EOMONTH(A2,0))+DAY(B2)/DAY(EOMONTH(B2,0)))

If you like to represent this result as a rational number I suggest to use sbNRN.