Counting the number of cells that are in a date range?

[anewc1]

I would like to count how many employees have hire dates between two specific dates.

Employee Name Hire Date
Doe, Jane 7/31/06
Doe, Jim 8/5/06

Anyone know how to do this easily? DCOUNT is really confusing me. Thanks!

 

[NBVC]

You can try using Countif():

If you want your dates hard-coded in the formula:

e.g.
=COUNTIF($B$2:$B$10,">7/30/2006")-COUNTIF($B$2:$B$10,">=8/5/2006")

If you want to reference dates in cells

e.g
=COUNTIF($B$2:$B$10,">"&G5)-COUNTIF($B$2:$B$10,">="&G6)


Where B2:B10 house the Hire Dates

G5 and G6 hire reference start & end dates.

 

[anewc1]

That didn't work. This is what the formula ended up being:

=COUNTIF($D$1:$D$1000,">"&L45)-COUNTIF($D$1:$D$1000,">="&L46)

Where L45 is 7/31/06 and L46 is 8/5/06. The value returned should have been 3 and it gave me 49.

 

[NBVC]

Here's what I get using your formula and some random dates in column D:

Book2
	D	E	F	G
1	5-Jul		4
2
3
4	31-Jul
5
6	4-Aug
7
8
9
10
11	10-Aug
12
13
14
15	3-Aug
16
17
18
19
20	10-Jun
21
22
23	2-Aug
24
25
Sheet1

Double-check your entries and your start/end dates to make sure they are compatible.

 

[anewc1]

Got it. I had to use this:

=COUNTIF($D$2:$D$100,">=7/31/2006")-COUNTIF($D$2:$D$100,">8/5/2006")

Thanks for your help, this will save me LOADS of time!