I've looked and I think I'm close but no cigar.


I'm trying to figure out how to Countif a range that represents each month. There is no constant for each month. I mean that there isn't a set amount of data for each. January could have 22 cells, Feb could have 20. It changes from month to month. Currently, I have to manually update the formula in column D to match the range that corresponds to each date.

What I would like is a formula that would would find the end of data for January and count if it's <24hrs.

Book32.xlsx