[Excel] Counting Months w/o overlap?

Author	All Replies
PhoenixDown -- Wants FIOS Premium join:2003-06-08 Fresh Meadows, NY kudos:1	[Excel] Counting Months w/o overlap? I have a spreadsheet and each row has a start date and an end date. I would like to count the number of months but I can't include overlapping periods. Col C = Start Date \| Col D = End Date January 2012 \| April 2012 February 2012 \| May 2012 This would be 5 months = Jan through May I am wondering if there's an excel command to sum this up. -- 1/22/2012 Delegate Count Newt 25 \| Romney 14 \| Ron Paul 10 \| Santorum 8
	to forum · permalink · 2012-08-01 12:09:39 ·
markofmayhem Why not now? Premium join:2004-04-08 Pittsburgh, PA kudos:5	=MONTH(MAX(D1:D9999) - MIN(C1:C9999)) + 1 See if that works, replace 1 and 9999 with appropriate row numbers.
	to forum · permalink · 2012-08-01 15:05:39 ·
PhoenixDown -- Wants FIOS Premium join:2003-06-08 Fresh Meadows, NY kudos:1	reply to PhoenixDown That didn't quite work but this brought was close enough. =(MAX(D9:D30) - MIN(C9:C30))/30 Appreciate your help in pointing me in the right direction!! Learned something new out of this. -- 1/22/2012 Delegate Count Newt 25 \| Romney 14 \| Ron Paul 10 \| Santorum 8
	to forum · permalink · 2012-08-01 16:37:10 ·

OS and Software > Microsoft Help > [Excel] Counting Months w/o overlap?