Thread: DATEDIF?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Ken Ken is offline
external usenet poster
 
Posts: 590
Default DATEDIF?

Yes ... (365.25/12) ... is close enough ... Thanks ... Kha

"MyVeryOwnSelf" wrote:

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.