NetworkDays: Dates and conditional formatting

  • Thread starter Thread starter Mike
  • Start date Start date
M

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
 
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
 
Hi Fred, how do I have it not to include weekend days - can I use the
Networkdays within the conditional formatting formula?
 
Back
Top