I modified the

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

slightly and used an OR instead to cover seberal dates but thisworked great.

I ended up with:

=IF(OR(MONTH(L6)=3,MONTH(L6)=6,MONTH(L6)=9,MONTH(L 6)=12),AVERAGE(M6:M8),"")

Thanks


"pinmaster" wrote:

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