problem counting rows in a Month

Hi,

In one of my Coloms I've the following data:

Date
24-nov-2016 12:12:43
09-nov-2016 18:28:45
10-nov-2016 05:30:46
17-nov-2016 07:35:25
22-nov-2016 11:45:10
23-nov-2016 14:18:56
23-nov-2016 14:14:26
04-nov-2016 07:04:53
09-nov-2016 00:34:09
31-okt-2016 20:11:01
24-nov-2016 15:08:59
29-nov-2016 10:53:59
27-nov-2016 15:37:42
04-dec-2016 20:28:42
04-nov-2016 20:30:56
09-nov-2016 09:32:41
17-nov-2016 14:40:30
11-nov-2016 18:33:02
01-dec-2016 15:13:07
29-nov-2016 13:59:49
04-dec-2016 09:52:49
29-nov-2016 11:40:16
16-nov-2016 09:47:43

I want to count all rows with are before dec 2016 (dec not included)
In this case only 20. I need the year and the month in my formule because of the future
I Know I've to use the count function.
How can I fix this.

Originally Posted by Tony Valko

Try this...

Enter 12/1/2016 in cell C1, then:

=COUNTIF(A:A,"<"&C1)

You may have to replace the comma with a semi-colon.

tnx for your help.