OR Function

[Wendy]

Hi

I have a problem with my or function. It should report the number of days
before today.

=(IF(OR(E5="0",E5<A5),"Invalid date",DAY(A5-E5)))

A5= today's date, E5 = any date
I want future dates marked as "Invalid date requested"
If E5 is a past date it works, but sometimes E5 is a future date, if I
change E5>A5 it shows every date as invalid.

Thanks

Wendy

 

[Arvi Laanemets]

Hi


=IF(OR(E5="0",E5<A5),"Invalid date",E5-A5)

 

[Arvi Laanemets]

Somewhat better one

=IF(OR(E5*1=0,E5<A5),"Invalid date",E5-A5)