CountIf Date is less than today

[gheyman]

I have dates going down column M starting in row 5. I want to count how many are less than today

Any help is appreciated.

Thank You

 

[Toadstool]

	K	L	M
4	Today	Count	Dates
5	07-Sep-19	8	11-Nov-18
6			23-Dec-18
7			03-Feb-19
8			17-Mar-19
9			28-Apr-19
10			09-Jun-19
11			21-Jul-19
12			01-Sep-19
13			13-Oct-19
14			24-Nov-19
15			05-Jan-20
16
17

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula K5 =TODAY() L5 =COUNTIF($M$5:$M$2046,"<"&K5) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>