Evaluate based on Actual Month
Oops typo, too many parentheses
=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...................
"Ken Wright" wrote in message
...
=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
|