Dumb quick question

[buggabooed]

I don't know why I'm making this so difficult, I simply want the following.

If the date in cell B9 = a date in January, say 01/09/2017, return a 1 in cell A9. If the date in cell B10 = a date in May, say 05/25/2017, return a 5 in A10.

Column B is full of dates. Is this harder then I'm imagining?

This is what I have so far. =IF(B9="*"&1&"*",1,0), but it always engages "0".

Any help is greatly appreciated.

 

[footoo]

=month(b9)

 

[buggabooed]

=month(b9)

Wow! Infinitely easier than I was trying to make it. Geez...always the little things with me I get stuck on and make too hard.

Thank you very much! I appreciate it.