Home |
Search |
Today's Posts |
#1
|
|||
|
|||
months between 2 dates!!!
A few weeks ago I posted a thread asking for a formula to count number of months between 2 dates with partial months counted as whole months. Here is what my spreadsheet looked like: START END TOTAL DATE DATE MONTHS 1/1/2005 4/29/2005 4 The formula I used is as follows: =IF(I51="","",MONTH(I51)-MONTH(H51)+1) Now in actually using the sheet I found that this formula is basically useless when the difference between the 2 dates exceeds a year for example: START END TOTAL DATE DATE MONTHS 1/1/2005 4/29/2006 4 Does anyone know what formula I can enter so that the fact that the total months exceeds a year will be counted as such? In the second example I provided I want it to say 16 months, not 4. Any help will be greatly appreciated! -- speary ------------------------------------------------------------------------ speary's Profile: http://www.excelforum.com/member.php...o&userid=24959 View this thread: http://www.excelforum.com/showthread...hreadid=397218 |
#2
|
|||
|
|||
I seemed to have figured it out... =IF(I51="","",(YEAR(I51)-YEAR(H51))*12+MONTH(I51)-MONTH(H51)+1) but if anyone sees why this may not work please let me know...thank you -- speary ------------------------------------------------------------------------ speary's Profile: http://www.excelforum.com/member.php...o&userid=24959 View this thread: http://www.excelforum.com/showthread...hreadid=397218 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I take a column of dates and add six months? | Excel Worksheet Functions | |||
Calculate number of months between 2 dates | New Users to Excel | |||
Need More Help on Dates to Months | Excel Worksheet Functions | |||
I want to subtract 2 dates and display the result as months | Excel Worksheet Functions | |||
How do I display months and years between two dates | Excel Discussion (Misc queries) |