Convert Month Number to its Text Name

[JEB85]

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
I’m wanting to allow the user to do some extraction based on an entered month and an entered year.<o></o>
<o> </o>
In cell C2 they enter the month e.g. March<o></o>
In cell C3 THEY ENTER THE YEAR e.g. 2010<o></o>
<o> </o>
My data set runs from B6:P1006 (row 6 houses the field names)<o></o>
<o> </o>
I have a list of dates in H7:H1006.<o></o>
<o> </o>
My plan is to use advanced filter to extract the dates based on what’s entered in cells C2 & C3.<o></o>
<o> </o>
In cell R7 (the criteria element of the advanced filter) I’ve entered the formula =AND(YEAR(H7)=$C$3,MONTH(H7)=$C$2)<o></o>
<o> </o>
The problem is is that the month function produces a number, how do I go about converting it to its text name? e.g. so 2 would be recognised as February?<o></o>
<o> </o>
Thanks<o></o>

 

[VoG]

Try

=AND(YEAR(H7)=$C$3,TEXT(H7,"mmmm")=$C$2)

 

[JEB85]

Just the job! Don't know why i didn't think about that.

Thanks