View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default NetworkDays: Dates and conditional formatting

Use a conditional format of:

=b1a1+2

No need for Networkdays

Regards,
Fred

"Mike" wrote in message
...
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