For crying out loud I missed the second one:


=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.............................

snip