View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ron Luzius Ron Luzius is offline
external usenet poster
 
Posts: 10
Default Complex If/Or/And formula

Nope. Neither formula worked correctly.
I am gonna wrap my head with duct tape B4 it explodes!

The formula as it stands now is;

=OR(ISBLANK(G2),OR(TODAY()-WORKDAY(G2,0)<=7,ISBLANK(H2)),AND(TODAY()-WORKDAY(G2,0)<=7,OR(TODAY()WORKDAY(H2,0),WORKDAY( (H2),0)<=TODAY())))

Conditionals
IF G2 is Blank
or
IF G2 <= 7 Workdays from Today() and H2 is Blank
or
IF G2 <= Today() and H2 <= 7 Workdays from Today()

G H I J
Planned Revised Should I am
Date Date Be Getting
2 03/01/10 True True
3 03/01/10 03/30/10 False False
4 03/01/10 03/18/10 True False
5 03/23/10 True True
6 03/23/10 03/28/10 False True
7 03/23/10 04/11/10 False True


--- news://freenews.netfront.net/ - complaints: ---