Hi,

Try:

=IF(AND(DAY(A1)=30,MONTH(A1)=6),TRUE,FALSE)

HTH
Jean-Guy

"The BriGuy" wrote:

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