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
|