Count before a certain date formula

yessir

Board Regular
Joined
Jun 7, 2019
Messages
81
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​
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,929
Office Version
  1. 365
Platform
  1. Windows
Here is one way.

Let's say that your data is in range A1:A100.
Then you can use this formula:
Excel 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

Well-known Member
Joined
Mar 22, 2019
Messages
664
Office Version
  1. 365
Platform
  1. Windows
Code:
=COUNTIF(A1:A100,"<"&38143)
 

Watch MrExcel Video

Forum statistics

Threads
1,114,513
Messages
5,548,496
Members
410,840
Latest member
Kar3ousse
Top