If the month in A4 is text as in October and the result in A1 is for
instance 10/28/2009 than you can use

=IF(TEXT(A1,"mmmm")=A4,"Goal Setting","Monthly Feedback")

--


Regards,


Peo Sjoblom


"KimW" wrote in message
...
How do I compare the results of a formula with the text in another field?
Example: I have a formula that is calculating a date (mm/dd/yyyy) in cell
A1.
I want to compare that to the Month (text) in cell A4 and in cell A5
return
"Goal Setting" if the result is TRUE and "Monthly Feedback" if the result
is
FALSE