I have the last formula that works great, but lets say this

I have a date in one colm / and a type in another colm

date / hearing type
01/02/09 / rh
01/02/09 / prelim
06/02/09 / rh
05/30/09 / prelim

that it will only count the dates that are not past due.

so in the case it would only count 1 rh and 1 prelim cause there are only 2 that have dates that have not arrive yet. and 2 that are past due. I just want it to count the ones that have not arrive.