Hi. I'm doing an excel challenge for a prospective job and I need help with the last 2 problems. The answers have to come in the form of a formula.

The first is a formula that counts the appearances of a specific month (June). The dates are listed in column E (range E2:E252) and are in the m/dd/yyyy format.

The second problem is more challenging and I will post it after I solve the first one with your help.

Thank you in advance.