hello, if dates are present in sheet2, i would display count of days opened & closed by months & locations. opened: dates present in allocating months & location. closed. dates missing in correlating motnhs. exception: only count < today.
Solved by O. J. in 18 mins