View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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