Hi Roy,

Glad it worked for you. You could try this to search on the month:

=IF(MONTH(A2)=MONTH(C$1),B2,"")

and copy it down. The limitation here is that if you have dates
spanning several years and you put 1st Jan 2006 in C1, then you will
have January details showing for all years. You can use the YEAR( )
function with AND to refine this.

Hope this helps further.

Pete