NetworkDays: Dates and conditional formatting
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" wrote:
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
|