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!
Bookmarks