If statement using date format as logical_test

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

Try this:

=IF(MONTH(B2)=1,"Jan","Blah")

Wait so you just want the month placed in C? Thats how you explain it....I think. Why not just do this....

=TEXT(MONTH(B2),"MMM")

You can also just place the =MONTH() function in C2 as:

=MONTH(B2)

Normally, the result will be a number, but you can format the cell to show the actual
month by using Format,Cells,Number,Custom and using the code mmm or mmmm.

Or wrap with TEXT

Thanks for your help guys!