With listed date in A1, try:

=TEXT(A1,"mmdd")=TEXT(TODAY(),"mmdd")

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"The BriGuy" <The wrote in message
...
I have a coumn that I simply put dates into. What I want to do is if the
month and day = certain criteris then TRUE results, if not then FALSE.
For
exaple the date listed is 6/30/06 so if the date is 6/30/any year then
this
is a TRUE statement.

I know this is probably simple but I seldom use EXCEL.

Thanks