I am trying to count the number of cells that contain a Y in a particular
column IF the data in another column IS a date. I have tried a variation of
the COUNTIF formula together with the AND function but it doesn't appear to
like me using them together. Any ideas much appreciated.

The date column is A cells 2:1528 and the Y or N appears in the X column
also from cells 2:1528.

please help!

thanks

Pete