NetworkDays: Dates and conditional formatting

[Mike]

Hi ya, I have NETWORKDAYS installed and using 2003.
I have a Start date in cell A1 and an End date in B1. I need to find out if
the date in B1 is 2 days greater than the start date in A1, I wish to color
code cell B1 in Red.

Thanks and much appreciate all your help guys


Regards
Mike

 

[Fred Smith]

Use a conditional format of:

=b1>a1+2

No need for Networkdays

Regards,
Fred

 

[Mike]

Thanks Fred, I thought it would not be so complicated

Cheers
Mike

 

[Mike H]

Mike,

I don't believe you can use networkdays in conditional formatting so if you
want to color a cell that is more then 2 working days greater than another
use this in B2 as a conditional format check against A1

=SUMPRODUCT(INT((B1-WEEKDAY(B1+1-ROW(INDIRECT("2:6")))-A1+8)/7))>2

Mike

 

[Mike]

Hi Fred, how do I have it not to include weekend days - can I use the
Networkdays within the conditional formatting formula?

 

[Mike]

You star! Mike H, thanks a million