Hi all,

I'm looking for a countif formulae that will that will look only within a certain range of dates, for cells that contain a certain text.

I have a massive spreadsheet tracking data from the past 4 years and into the future.

I have one column (Column M) of dates, I want to only look at data between 1 Oct 2020 - 31 Dec 2020.

I have a different column (Column O) that contains text "On Time", "Late".

So, I want to count the number of "On Time" between 1 Oct 2020 and 31 Dec 2020.

Any help is appreciated.