OR Function
 

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 E5A5 it shows every date as invalid.

Thanks

Wendy

OR Function
 

Hi


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


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )




"Wendy" wrote in message
...
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 E5A5 it shows every date as invalid.

Thanks

Wendy

OR Function
 

Somewhat better one

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



--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )