Conditional Month Counting Function
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
You might find this useful: http://www.cpearson.com/excel/datedif.aspx
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks