Hi,

You don't have to do that. Try this

A1 B1
10/11/2008 Nov 2008

then the formula
=Month(a1)=Month(b1)

and you will see it evaluates as TRUE so do your criteria validation like that

Mike

"Cam1234" wrote:

Hi All,

I have a bunch of data that I am matching by month. To make my formula
work, I need all the dates to be exactly the same, but for example, for
November I have data of the 1st, 2nd, 10th etc.

I'm using a formula to look up any values that match, for example, Nov-2008.
This is of course 01/11/2008, so it dosn't pick up anything between
02/11/2008 and 30/11/2008.

How do I make all of the dates like "30/11/2008" to just be Nov-2008?

Thanks!