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)

"jennifer" wrote in message
...
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!