dslreports logo
site
 
    All Forums Hot Topics Gallery
spc

spacer




how-to block ads


Search Topic:
uniqs
451
share rss forum feed


PhoenixDown
FIOS is Awesome
Premium
join:2003-06-08
Fresh Meadows, NY
kudos:1
Reviews:
·Verizon FiOS

[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



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.


PhoenixDown
FIOS is Awesome
Premium
join:2003-06-08
Fresh Meadows, NY
kudos:1
Reviews:
·Verizon FiOS
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