Ps. If you have other numbers in column B, it's more difficult to distinguish
real dates from plain old numbers.

Dan wrote:

I need to countif 2 diff criteria's are met in diffrent columns for ex:
A B

1. FCC 18/01/2008
2. FID 18/01/2008
3. PTZ 16/01/2008
4. FCC 22/01/2008

If FCC in appears in column A1 and there is a date in B it must count it as
1 in case the answer would be =2
Any ideas ?

--

Dave Peterson