I am trying search & count 2 or more words within a cell using a worksheet function. See below example:

The texts are in A1 (only)
Entered by John at 02:19 PM on 02/13/2007
Entered by Smith at 02:20 PM on 02/13/2007
Entered by John at 02:30 PM on 02/13/2007
Entered by John at 02:21 PM on 02/12/2007
Entered by John at 02:22 PM on 02/11/2007

The words I am looking for are "John" and "02/13/2007" and the count should be 2. I bolded what should be counted.Can you help me?

Your help on this is appreciated.

Statsman