Formula for counting if someone dates expired and no future date booked in

Hi thanks in advance for help.

I have two columns of data one with the date of expiry for training and the one next to it with future dates booked in.

I would like a formula to look at the first column and if the date is less than today's date and in the corresponding cell there is no date booked in or no writing (emailed, pending etc)

I am expecting the following table to give me a count of 2 - cells C4 and C6 (see attachment)

Name Training
Expiry Date Future Enrolled Date
Staff 1 06/05/19 06/05/18
Staff 2
Staff 3 13/01/20
Staff 4 15/01/17
Staff 5 20/02/17 04/05/17
Staff 6 20/02/17 Emailed
Staff 6 20/02/17 Pending

sorry - it was unclear ...i'll try again ...

1 A B C
2 Name Expiry Date Future Enrolled Date
3 Staff 1 06/05/19 06/05/18
4 Staff 2
5 Staff 3 13/01/20
6 Staff 4 15/01/17
7 Staff 5 20/02/17 04/05/17
8 Staff 6 20/02/17 Emailed
9 Staff 6 20/02/17 Pending

In the expiry date column (B) I would like the formula to look and see if the date is previous than today's date.

Then I would like the formula to look at column C - which has dates and text and to see if anything is in those cells (ie not blank)

I would like the formula to count up the number of times there is an out of date in B and a blank in C

so in the example I am expecting to get a count of 2

Please let me know if it is still unclear

many thanks

the attachment shows the example better as its in excel

excellent thanks - i'll give that a try