Ron

Using your conditions and example the following formula will work
calculating on working days. You do need to be careful though as in your
example row 4 has an expected date of 03/18/10, with an expected condition of
true, but the date is still within 7 working days of your posting, so i would
expect false. To use the function NETWORKDAYS you need to add in the
'Analysis Toolpak' from the menu - Tools-Add-Ins...-Analysis Toolpak check
box ticked-OK - if the check box was not previously ticked excel will need
to be closed and re-opened to use the addin. This is a one off operation.

=OR(ISBLANK(G2),AND(NETWORKDAYS(G2,TODAY())7,ISBL ANK(H2)),AND(G2<=TODAY(),NETWORKDAYS(H2,TODAY())7 ))

If you really wanted calander days then the next equation will do the job
without any add-ins required.

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

The above is based on the assumption that you want to be warned when dates
in G2 exceed 7 days from the current date...

Best of luck





"Ron Luzius" wrote:

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: ---
.