Month (datedif) to 1 decimal

J

jennifer

Hello! Is there a way to calc the # of months between dates to 1 decimal
place? Other than taking the difference between 2 dates and dividing by 30.

Thanks!
 
B

Bob Phillips

DATEDIF can calculate the number of whole months, like so

=DATEDIF(A21,B21,"M")

there is no way that I now of to get to one decimal place because of the
different number of days in each month the algorithm is somewhat tricky. You
could do an approximation with

=DATEDIF(A21,B21,"YM")+DATEDIF(A21,B21,"MD")/30

which is a little better than (B21-A21)/30


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
C

Creator

Hi Jennifer,
Try this
=YEARFRAC(C8,G8)*12

C8 and G8 being the cells with the two dates. Format cell to 1 decimal place
as required.
 
Top