Conditional Month Counting Function

[run2win17]

Hello, I'm looking for some help. I need Excel to calculate how many months are falling between two dates, assuming 30 days per month. IE 3/31/2010 - 5/1/2010 would return 1 instead of 1.03. In the date range, the end date (ie 5/1 above) is not included. The Start date is included, except in the example above, the 31st isn't included because it assumes 30 days per month... make sense? I attached an Excel file with what the answers should be in the highlighted area, but looking for a formula that calculates how many months in the range are in each of the year ending columns. Thanks for your help!!!

Ben

[Domski]

You might find this useful: http://www.cpearson.com/excel/datedif.aspx

Dom