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

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

Thanks Fred, I thought it would not be so complicated

Cheers
Mike


"Fred Smith" wrote:

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

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

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


"Fred Smith" wrote:

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

You star! Mike H, thanks a million
--
Regards
Mike


"Mike H" wrote:

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