Thread: How can I calculate fractional months between two dates?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default How can I calculate fractional months between two dates?
=DATEDIF(A1,A2,"m")+DATEDIF(A1,A2,"md")/30 and format as General.
Adjust the formula to suit your interpretation of how many days are in a
month.
--
David Biddulph

"JulesMacD" wrote in message
...
I have two dates: December 31, 2008 and June 16, 2008. I'd like to be
able
to show the difference as 6.5 months. Any ideas? I've tried the datedif
formula but it returns 6. Thank you.


Reply With QuoteReply With Quote