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!