Oops, misread month(x)=8 for month(x)=8.

Try:

=IF(OR(MONTH(x)<8,AND(MONTH(x)=8,DAY(x)<8)), "Yes", "No")

instead.

Alternatively:

=IF(DATE(9999,MONTH(x),DAY(x))<DATE(9999,8,8),"Yes ","No")

In article ,
JE McGimpsey wrote:

One way:

=IF(OR(MONTH(x)<8, DAY(x)<8), "Yes", "No")

In article ,
palhota wrote:

Hello all. How can I represent in the function bar the following logical
function?

If ((month(x) < 8)or (month(x)=8 and day(x)<8))

Thanks a lot in advance