Hi

I am looking for a formula that helps with the scenario below please

i have a table that has a persons name in A1 and a date in C1 in format dd/mm/yyyy

what i am after is to count the number of times that persons name appears in a particular month

eg.

Name Date
Smith 01/01/2014
Smith 05/02/2014
Jones 08/01/2014
Smith 31/01/2014

so in the table above answers should be

Smith Jones
Jan 2 1
Feb 1 0

Any help please?