| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I calculate fractional months between two dates?
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. |
|
#2
|
|||
|
|||
Answer: How can I calculate fractional months between two dates?
__________________
I am not human. I am an Excel Wizard |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I calculate fractional months between two dates?
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I calculate fractional months between two dates?
=(B1-A1)/30.4375 and format as a number
-- Gary''s Student - gsnu200791 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate Number of Months Weeks and Days Between Two Dates | Excel Worksheet Functions | |||
| Calculate number of months between dates | Excel Worksheet Functions | |||
| Calculate number of months between 2 dates | New Users to Excel | |||
| Calculate number of months between 2 dates | New Users to Excel | |||
| Calculate Years/Months Between Dates and then Average | Excel Discussion (Misc queries) | |||
Linear Mode
