hi, not good with dates, trying to have readout show: "next workday is a
holiday.. "
- to include today is sat/sun (having a problem with)
artificial set monday as a holiday
defined name HOL:
={"2010-01-01";"2010-01-11";"2010-01-18"}
fe3 = NOW() or: 2010.01.08 4:27:29 PM
(changing pc date to yesterday/today/tomarrow: sat)

have some items that work below /not labelled: yes / no.
last entry at top.. thanks in advance.
example: works: y/n

=TODAY()=WORKDAY($FE$3,0,HOL) works, but not if today is sat/sun
=TODAY()+1=WORKDAY($FE$3,1,HOL) wrong..
=WORKDAY($FE$3,1,HOL)-1 no/ trying to do fe3 +1 ??

=DATE(2010,1,8) basic/yes
=TODAY()=DATE(2010,1,9)-1 yes
=TODAY()=DATE(2010,1,8) yes
=SUMPRODUCT(--ISNUMBER(FIND(HOL,TODAY())))0 no
=WORKDAY($FE$3,1,HOL) yes
fe3 has NOW(): 2010.01.08 4:27:29 PM