Hi there,

I'm trying to do the following in excel, yet to no avail:

1) I have a date cell for B2, B3 etc etc eg. 29-Jan-10

2) What I want to do is: If month = Jan, enter Jan into C2, if month = Feb, enter Feb into C2, and so forth

3) This is what I've tried to test for Jan (I'll add the rest of the months in once I get Jan working)

=IF(B2="29/1/2010","Jan","Blah")
=IF(B2="*/1/*","Jan","Blah")
=IF(B2="*-1-*","Jan","Blah")
=IF(B2="*-Jan-*","Jan","Blah")

And the output is Blah every time...

Not sure if my logic is wrong here, or whether I've made a minor mistake, but I can't seem to get this to work.

Any help is greatly appreciated

Regards,
David