Count before a certain date formula

[yessir]

Looking to create a formula to count number of dates before June 15, 2004

Date

5/21/04​

4/15/04​

1/28/05​

1/28/05​

11/5/04​

9/18/04​

4/15/04​

3/17/05​

1/16/05​

4/10/05​

2/15/04​

1/10/04​

4/10/05​

4/15/04​

7/8/04​

6/26/04​

5/28/05​

7/27/05​

9/18/04​

7/8/04​

9/6/04​

6/2/04​

3/5/05​

1/10/04​

7/27/05​

2/9/05​

8/20/05​

6/9/05​

7/15/05​

3/17/05​

6/2/04​

7/15/05​

6/9/05​

7/15/05​

4/10/05​

5/9/04​

4/27/04​

3/17/05​

5/21/04​

4/22/05​

1/22/04​

4/22/05​

9/18/04​

2/3/04​

10/24/04​

3/5/05​

5/28/05​

4/22/05​

10/12/04​

4/3/04​

6/21/05​

5/21/04​

6/21/05​

10/12/04​

12/11/04​

1/4/05​

11/17/04​

3/22/04​

6/2/04​

4/22/05​

6/26/04​

1/16/05​

5/28/05​

3/22/04​

4/10/05​

7/8/04​

5/9/04​

4/15/04​

7/20/04​

8/8/05​

1/28/05​

1/22/04​

8/8/05​

11/29/04​

7/27/05​

12/23/04​

12/11/04​

7/20/04​

2/9/05​

10/24/04​

11/5/04​

2/27/04​

3/22/04​

8/25/04​

6/9/05​

7/8/04​

7/8/04​

1/16/05​

11/17/04​

3/29/05​

11/29/04​

4/10/05​

10/12/04​

7/8/04​

10/24/04​

1/4/05​

3/29/05​

11/5/04​

1/4/05​

3/22/04​

5/9/04​

3/17/05​

2/15/04​

3/17/05​

6/9/05​

12/23/04​

8/25/04​

4/15/04​

10/24/04​

6/9/05​

11/29/04​

8/13/04​

5/9/04​

3/22/04​

2/9/05​

8/20/05​

7/20/04​

8/1/04​

3/10/04​

7/3/05​

1/28/05​

3/22/04​

4/22/05​

9/18/04​

7/20/04​

11/17/04​

7/8/04​

8/1/04​

3/29/05​

9/30/04​

3/22/04​

6/21/05​

9/30/04​

4/15/04​

7/8/04​

1/28/05​

3/5/05​

9/18/04​

4/22/05​

6/14/04​

4/3/04​

2/15/04​

2/21/05​

5/16/05​

11/5/04​

11/5/04​

4/15/04​

2/15/04​

12/11/04​

10/24/04​

9/18/04​

8/20/05​

2/3/04​

8/13/04​

6/21/05​

8/25/04​

5/16/05​

2/3/04​

5/16/05​

4/3/04​

6/26/04​

3/22/04​

12/23/04​

10/12/04​

5/9/04​

3/22/04​

9/30/04​

8/25/04​

6/9/05​

3/5/05​

11/17/04​

1/22/04​

2/21/05​

12/23/04​

1/16/05​

4/22/05​

7/27/05​

2/9/05​

7/20/04​

5/9/04​

9/30/04​

1/4/05​

7/20/04​

8/8/05​

2/21/05​

3/22/04​

2/3/04​

8/25/04​

8/20/05​

5/9/04​

6/9/05​

4/27/04​

4/27/04​

7/8/04​

1/28/05​

4/10/05​

3/10/04​

7/27/05​

4/10/05​

8/13/04​

7/27/05​

11/29/04​

8/8/05​

7/3/05​

1/4/05​

7/3/05​

11/5/04​

11/17/04​

3/5/05​

2/27/04​

6/14/04​

3/10/04​

8/13/04​

1/4/05​

5/4/05​

11/17/04​

2/9/05​

4/10/05​

5/16/05​

3/29/05​

6/26/04​

1/22/04​

12/11/04​

1/4/05​

9/6/04​

3/5/05​

3/5/05​

2/9/05​

2/15/04​

3/29/05​

3/29/05​

3/5/05​

2/21/05​

4/22/05​

5/9/04​

7/8/04​

1/4/05​

8/8/05​

6/14/04​

4/27/04​

5/16/05​

7/3/05​

10/12/04​

10/12/04​

8/25/04​

11/29/04​

3/5/05​

7/27/05​

4/10/05​

2/27/04​

11/5/04​

2/15/04​

8/1/04​

9/18/04​

6/26/04​

2/27/04​

12/11/04​

12/11/04​

9/30/04​

11/17/04​

10/24/04​

2/3/04​

3/29/05​

2/15/04​

12/23/04​

5/16/05​

11/29/04​

4/27/04​

3/29/05​

4/22/05​

6/14/04​

8/20/05​

5/21/04​

6/14/04​

7/3/05​

3/10/04​

1/28/05​

3/29/05​

2/9/05​

6/26/04​

12/23/04​

5/4/05​

10/12/04​

2/15/04​

5/4/05​

3/5/05​

1/10/04​

12/11/04​

9/6/04​

8/8/05​

2/27/04​

9/6/04​

7/15/05​

8/8/05​

4/3/04​

3/22/04​

8/8/05​

11/29/04​

8/25/04​

10/12/04​

4/10/05​

6/9/05​

3/22/04​

6/2/04​

2/15/04​

7/20/04​

5/28/05​

9/6/04​

8/1/04​

7/8/04​

3/22/04​

6/14/04​

7/27/05​

9/6/04​

3/5/05​

8/1/04​

12/23/04​

6/2/04​

6/21/05​

11/17/04​

6/2/04​

5/28/05​

8/20/05​

5/16/05​

9/6/04​

1/28/05​

12/11/04​

2/21/05​

11/17/04​

4/27/04​

5/16/05​

7/20/04​

3/17/05​

8/20/05​

11/17/04​

4/10/05​

5/16/05​

5/4/05​

10/24/04​

10/12/04​

4/27/04​

4/3/04​

8/1/04​

3/29/05​

2/27/04​

9/30/04​

3/5/05​

8/25/04​

11/17/04​

2/9/05​

2/21/05​

10/24/04​

10/24/04​

6/14/04​

11/29/04​

4/22/05​

11/29/04​

2/27/04​

4/27/04​

8/25/04​

10/12/04​

4/10/05​

3/10/04​

7/15/05​

11/5/04​

12/23/04​

2/3/04​

5/16/05​

2/15/04​

4/15/04​

5/21/04​

5/21/04​

2/15/04​

7/15/05​

5/28/05​

3/17/05​

9/6/04​

5/4/05​

8/1/04​

6/26/04​

8/1/04​

1/28/05​

4/3/04​

5/21/04​

4/27/04​

8/8/05​

6/26/04​

2/27/04​

12/23/04​

8/25/04​

2/9/05​

5/28/05​

2/21/05​

5/4/05​

8/25/04​

8/20/05​

12/23/04​

3/10/04​

1/22/04​

9/18/04​

2/21/05​

7/3/05​

11/29/04​

2/15/04​

7/20/04​

9/18/04​

8/1/04​

7/15/05​

3/5/05​

10/12/04​

5/28/05​

3/5/05​

3/5/05​

3/29/05​

5/4/05​

3/10/04​

1/28/05​

7/8/04​

1/10/04​

5/4/05​

3/29/05​

4/10/05​

7/3/05​

4/22/05​

2/3/04​

9/6/04​

11/17/04​

3/10/04​

11/29/04​

11/17/04​

3/10/04​

1/4/05​

9/6/04​

4/10/05​

6/21/05​

4/3/04​

2/9/05​

11/29/04​

4/3/04​

10/24/04​

4/15/04​

9/6/04​

7/3/05​

8/25/04​

7/8/04​

4/10/05​

8/20/05​

10/12/04​

1/4/05​

5/21/04​

5/16/05​

3/5/05​

8/20/05​

4/22/05​

2/3/04​

1/28/05​

5/4/05​

7/20/04​

8/20/05​

5/4/05​

8/25/04​

10/12/04​

10/24/04​

8/13/04​

1/10/04​

1/10/04​

1/10/04​

4/22/05​

12/11/04​

8/1/04​

8/8/05​

12/11/04​

4/10/05​

9/18/04​

2/21/05​

9/18/04​

5/21/04​

2/3/04​

4/15/04​

7/20/04​

5/21/04​

4/15/04​

7/8/04​

3/17/05​

4/27/04​

6/2/04​

2/15/04​

8/20/05​

1/28/05​

4/10/05​

3/29/05​

1/22/04​

7/3/05​

1/16/05​

2/27/04​

2/27/04​

1/10/04​

4/10/05​

10/12/04​

12/23/04​

4/27/04​

1/22/04​

7/3/05​

1/10/04​

9/6/04​

4/10/05​

6/26/04​

11/17/04​

2/3/04​

7/3/05​

5/21/04​

9/30/04​

6/14/04​

9/18/04​

4/27/04​

8/25/04​

8/1/04​

3/29/05​

5/21/04​

11/5/04​

2/9/05​

5/16/05​

3/5/05​

7/8/04​

6/26/04​

11/29/04​

4/3/04​

11/5/04​

2/9/05​

9/6/04​

6/14/04​

8/20/05​

2/9/05​

5/21/04​

7/20/04​

2/15/04​

6/26/04​

2/15/04​

11/17/04​

9/30/04​

11/29/04​

1/16/05​

8/20/05​

9/30/04​

11/29/04​

2/9/05​

4/15/04​

12/23/04​

5/21/04​

10/12/04​

11/17/04​

5/9/04​

8/20/05​

4/3/04​

6/2/04​

3/22/04​

3/17/05​

4/15/04​

11/29/04​

8/13/04​

7/27/05​

6/9/05​

3/5/05​

3/5/05​

9/18/04​

7/20/04​

4/22/05​

2/27/04​

6/26/04​

4/22/05​

8/25/04​

8/1/04​

1/10/04​

7/20/04​

9/18/04​

2/3/04​

5/4/05​

9/6/04​

3/29/05​

2/27/04​

3/29/05​

11/29/04​

6/26/04​

3/17/05​

3/5/05​

11/17/04​

8/13/04​

6/14/04​

6/14/04​

4/3/04​

5/16/05​

9/6/04​

7/27/05​

4/10/05​

6/26/04​

8/8/05​

8/25/04​

6/26/04​

9/6/04​

4/10/05​

6/26/04​

3/5/05​

9/18/04​

7/3/05​

9/6/04​

7/15/05​

3/5/05​

5/9/04​

8/25/04​

6/26/04​

1/16/05​

5/4/05​

6/26/04​

11/5/04​

1/10/04​

4/15/04​

11/29/04​

3/17/05​

3/10/04​

7/15/05​

1/28/05​

8/13/04​

9/30/04​

4/22/05​

9/18/04​

5/28/05​

11/17/04​

2/15/04​

6/14/04​

3/10/04​

2/27/04​

2/27/04​

1/16/05​

11/5/04​

6/21/05​

5/9/04​

3/10/04​

2/9/05​

12/11/04​

3/22/04​

4/27/04​

4/10/05​

10/12/04​

4/27/04​

11/17/04​

2/21/05​

4/22/05​

11/17/04​

9/30/04​

2/15/04​

9/6/04​

4/3/04​

8/25/04​

4/3/04​

11/29/04​

6/9/05​

9/18/04​

10/24/04​

8/25/04​

2/27/04​

10/12/04​

10/24/04​

5/28/05​

1/22/04​

3/29/05​

9/18/04​

8/20/05​

11/17/04​

5/21/04​

8/25/04​

4/3/04​

3/5/05​

12/11/04​

7/3/05​

7/27/05​

11/5/04​

2/27/04​

1/16/05​

3/10/04​

2/21/05​

1/22/04​

5/21/04​

1/22/04​

11/17/04​

5/21/04​

2/21/05​

2/9/05​

7/3/05​

1/22/04​

8/1/04​

10/24/04​

10/24/04​

5/4/05​

10/12/04​

5/9/04​

8/20/05​

7/15/05​

4/3/04​

9/30/04​

5/21/04​

5/21/04​

2/27/04​

6/9/05​

6/26/04​

2/3/04​

7/3/05​

1/4/05​

11/29/04​

4/3/04​

8/25/04​

2/3/04​

8/1/04​

2/9/05​

5/28/05​

10/12/04​

3/17/05​

6/2/04​

1/28/05​

5/9/04​

3/22/04​

5/21/04​

7/8/04​

4/3/04​

8/1/04​

10/24/04​

3/17/05​

2/3/04​

7/20/04​

6/14/04​

8/8/05​

6/14/04​

9/18/04​

11/17/04​

8/1/04​

3/5/05​

5/28/05​

4/27/04​

12/23/04​

5/16/05​

9/18/04​

8/8/05​

8/20/05​

8/8/05​

12/23/04​

6/26/04​

10/24/04​

7/20/04​

11/29/04​

2/9/05​

9/6/04​

6/2/04​

8/1/04​

6/26/04​

10/24/04​

7/3/05​

8/13/04​

8/20/05​

6/21/05​

1/10/04​

4/15/04​

2/27/04​

3/22/04​

8/20/05​

1/22/04​

5/9/04​

4/3/04​

11/5/04​

1/16/05​

12/23/04​

2/3/04​

8/25/04​

1/16/05​

7/27/05​

7/8/04​

2/21/05​

2/15/04​

8/20/05​

2/9/05​

8/25/04​

1/4/05​

1/28/05​

2/27/04​

1/4/05​

12/11/04​

2/21/05​

6/9/05​

7/3/05​

11/17/04​

9/6/04​

9/6/04​

2/15/04​

2/27/04​

4/3/04​

5/28/05​

8/25/04​

1/16/05​

9/18/04​

12/11/04​

3/29/05​

1/10/04​

6/14/04​

4/27/04​

4/10/05​

1/16/05​

5/28/05​

11/29/04​

1/10/04​

1/4/05​

4/27/04​

10/24/04​

5/16/05​

4/10/05​

12/23/04​

2/15/04​

1/22/04​

11/29/04​

7/27/05​

9/30/04​

12/23/04​

7/27/05​

8/8/05​

10/12/04​

2/3/04​

1/22/04​

6/2/04​

7/15/05​

2/27/04​

2/21/05​

7/27/05​

6/2/04​

9/30/04​

6/14/04​

5/21/04​

3/10/04​

5/4/05​

6/21/05​

8/1/04​

8/13/04​

1/10/04​

10/24/04​

7/20/04​

7/8/04​

7/20/04​

11/5/04​

11/5/04​

5/9/04​

7/3/05​

9/30/04​

1/10/04​

5/28/05​

5/9/04​

4/10/05​

2/15/04​

8/20/05​

5/9/04​

1/22/04​

7/27/05​

1/28/05​

9/30/04​

8/20/05​

6/14/04​

3/29/05​

8/1/04​

3/5/05​

5/16/05​

6/2/04​

6/21/05​

11/5/04​

3/22/04​

4/27/04​

3/22/04​

10/24/04​

2/9/05​

6/2/04​

7/8/04​

4/15/04​

4/3/04​

6/14/04​

3/5/05​

1/28/05​

8/25/04​

8/20/05​

8/1/04​

6/26/04​

4/22/05​

2/21/05​

11/5/04​

4/15/04​

9/30/04​

9/30/04​

12/23/04​

7/20/04​

1/10/04​

10/12/04​

2/9/05​

7/20/04​

8/1/04​

5/4/05​

8/20/05​

9/18/04​

9/18/04​

3/22/04​

11/29/04​

2/9/05​

3/22/04​

6/26/04​

5/28/05​

6/26/04​

10/24/04​

3/17/05​

6/2/04​

1/28/05​

2/3/04​

2/27/04​

8/8/05​

11/17/04​

11/17/04​

7/20/04​

3/5/05​

4/3/04​

12/23/04​

7/20/04​

2/9/05​

7/8/04​

5/16/05​

3/5/05​

1/16/05​

8/13/04​

1/22/04​

7/15/05​

1/28/05​

1/22/04​

7/20/04​

3/10/04​

3/22/04​

8/1/04​

5/9/04​

1/28/05​

1/4/05​

10/12/04​

8/20/05​

4/3/04​

6/9/05​

11/29/04​

11/17/04​

2/27/04​

7/20/04​

4/15/04​

5/21/04​

11/5/04​

8/1/04​

 

[Joe4]

Here is one way.

Let's say that your data is in range A1:A100.
Then you can use this formula:

=COUNTIF(A1:A100,"<=" & DATE(2004,6,15))

Note: In the future, it isn't necessary to include a very large range/image in your post. A few rows so we can see what your data looks like will suffice.

 

[VBE313]

=COUNTIF(A1:A100,"<"&38143)