=IF(MONTH(A1)=5),value_if_true, value_if_false)
(Jan=1, Feb=2, Mar=3 etc)

or

=IF(TEXT(A1,"mmm")="May"),value_if_true, value_if_false)

Regards
Ken...................


"RJJ" wrote in message
...
I am (with the help of this forum) successfully pulling data from a range
of
cells. The range I set up was data for the month of May. What should I
preceed a formula with to say If May, use range XX:XX, If June use range
XX:XX, and so on. Of course each range is different than the next.

Richard