Logic question

[palhota]

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

 

[Mike H]

Maybe

=IF(OR(MONTH(A1)<8,AND(MONTH(A1)=8,DAY(A1)<8)),"Do This","Do That")

Mike

 

[JE McGimpsey]

One way:

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

 

[JE McGimpsey]

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")

 

[Roger Govier]

Hi JE

I may have interpreted the OP incorrectly, but I assumed that it was only
for Month = 8, the the Day could be less than 8.
I dismissed the same formula myself, as, if my interpretation is correct,
days 1 to 7 of Sep through Dec would return false true's.

 

[Rick Rothstein]

Let's assume 'x' is the cell reference A1 for this example and that it
contains a real date, then I would think you could use this...

=IF(A1<DATE(YEAR(A1),8,8),"It's True","It's False")