=COUNTIF('All Employees''
Training'!O1352:O1364,""&DATE(2005,12,31)-COUNTIF('All Employees''
Training'!O1352:O1364,"="&DATE(2006,2,1)))

if you want to count the dates for Jan 06 use the above AND if you only want
to check on a monthly basis you can use the below as well

=SUMPRODUCT(--(MONTH(Range)=1),--(YEAR(Range)=2006))


replace Range with the sheet name and the cell range


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com




"audreyglennette" wrote in
message ...
WAHOOO!!! It returned a 2. The correct answer! It worked! Once I
understood
what you guys were saying to do. Thanks!
But now it has a new issue: I decided to test it by adding in some fake
entries (2/1/06, 2/2/06, and 1/2/06), so the answer should now be 3; it is
returning a 5. It's counting the other two Feb entries too?!

Here's what I have:
=COUNTIF('All Employees''
Training'!O1352:O1364,""&DATE(2005,12,31)-COUNTIF('All Employees''
Training'!O1352:O1364,"<"&DATE(2006,2,1)))