DATEDIF?
I need to determine fractional MONTHS between 2 Dates to 1 decimal
place (17.3 months).
Fractional months is a difficult concept to grasp when you consider
that a month is not a uniform unit of measure. A month can have from
28 to 31 days.
True, but on the average there are 365.25/12 days in a month. If that's
close enough for the OP, then something like
=(A2-A1)/(365.25/12)
might satisfy the need. Format the result as a number.
|