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