Yes, that is exactly what I am trying to do: check monthly & weekly.

Is there someway to check weekly? Or will I have to use:
=COUNTIF('All
Employees''Training'!O1352:O1364,""&DATE(2005,12, 31)-COUNTIF('All
Employees''Training'!O1352:O1364,"="&DATE(2006,2, 1)))
and input the date ranges?

Scenaro: I am looking at training records and determining how many have
taken each course each month, and how many trainings per week, as well as who
is due for yearly training. The higher ups are asking me to justify my job.
If you can help with that yearly one, I would be eternally greatful. I was
thinking something like:
=COUNTIF('All Employees''Training'!O1352:O1364,"<"&DATE((TODAY() )-365)
Think it will work? I haven't tested it.

You guys have been so very helpful. Sincerest thanks.

"Peo Sjoblom" wrote:

=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)))