Thread: Logic question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default Logic question

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.

--
Regards
Roger Govier

"JE McGimpsey" wrote in message
...
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