Count if date is before value?

[dangerzone21]

I have a roster of employees and there is a column for the date of thei
last annual training. I am trying to have a total on the bottom of th
column that counts how many people are delinquent (havent had the clas
in over a year) in their training.

Looks like this:

Name Class Date
John Sexual Harassment 4/15/2003
Harry Sexual Harrasment 3/17/2003
Don Sexual Harrasment 4/1/2004
TOTA
REQQUIRED
2

2 would be the total if the date was set to 4/15/2004

I have tried COUNTIF(C2:C107">4/15/2004")

And other formulas, can anyone please hel

 

[Frank Kabel]

Hi
try
=COUNTIF(C2:C107,">" & DATE(2003,4,15))

 

[dangerzone21]

Unfortunately that did not work

 

[Frank Kabel]

Hi
what was the error?

you may try as an alternative:
=SUMPRODUCT(--(C2:C107<=DATE(2003,4,15)))

The problem for me is that I'm not so sure on your example data
(regarding the date you give, your test formula and your expected
result). The above formula would count all employes who have a date
less or equal than 15-April-2003