Hi Ron,

Thanks for your help but I could not get your suggestion to work correctly.
For example the 'Sum' formula that compares the set date and the forecast
date, when these two dates are the same, the result is 1 when I would expect
as answer if 0. Also when I enter your 'Formula is' into the conditional
formatting the cells do not change colour.

I'm obvously doing something wrong. Is there anyway I can send you my
examaple spreadsheet so that you can enter this information directly?

One other item that I forgot to mention. When a task is complete the cell
needs to be blue and contains the completion date. I don't know if there is
anyway that can be worked into the formula as well?

Appreciate your help

Paul

"Ron Rosenfeld" wrote in message
...
On Sun, 27 May 2007 15:14:51 +0100, "Paul"
wrote:

So, Ron do you have formula that would work? If it can't include Bank
Holiday then that will be okay.

Not including holidays, the following formula should work to compute the
number
of working days between two dates. A1 is the earlier date, B1 the later.

=SUM(INT((WEEKDAY(A1-{2,3,4,5,6})+B1-A1)/7))

Similar to the NETWORKDAYS function, this formula counts the starting
date.

Another option would be to use the NETWORKDAYS function in a hidden
column, and
then have your conditional formatting formula reference the contents of
that
hidden column.

e.g.

=NETWORKDAYS(forecast_date,due_date,holidays)

Then, in your conditional formattinge:

Formula Is: =cell_ref=11 (red)
Formula Is: =cell_ref= 6 (yellow)

Set the baseline color to be green.
--ron