Refer to 'custom' formatted date column in formula

Hi, I have a system generated report which has the date in CUSTOM formatted field. I am trying to create a summary report which counts instances which meet certain criteria including month. I have been using sumproduct and it works fine until I try and count the month information.

I have attached a sample to explain what I am trying to do - the formula in Cell G10 counts everything that has GUI in column B and DOES NOT contain BCG in column C - The result is correct.

The formula in cell G9 is the one I am trying to make work with the date criteria added - I have tried different variations of the date in the formula but it doesn't work. the data in column A is how it comes out of a different system and I don't want really have to mess about and change it I just want my summary sheet to update when I run this report and save it.

Any ideas?