How can I calculate fractional months between two dates?

J

JulesMacD

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.
 
D

David Biddulph

=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.
 
J

Jim Cone

This will get you close enough to satisfy most people...
=(A2-A1)/365*12
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)




"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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rounding UP Months' Difference between 2 dates 1
Summary of Difference between dates in years, months, days 3
difference between dates 2
Calculating time between mulitple dates 4
ROUNDING UP monthly differences 7
Datedif gives wrong result 1
Calculate Holding Period Returns Between Two Customizable Dates 1
Months between two dates 5

Top