dslreports logo
 
    All Forums Hot Topics Gallery
spc
Search similar:


uniqs
549

PhoenixDown
FIOS is Awesome
Premium Member
join:2003-06-08
Fresh Meadows, NY

PhoenixDown

Premium Member

[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.

markofmayhem
Why not now?
Premium Member
join:2004-04-08
Pittsburgh, PA

markofmayhem

Premium Member

=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 Member
join:2003-06-08
Fresh Meadows, NY

PhoenixDown

Premium Member

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.