Hi!

Business days = Monday thru Friday less any holidays?

This requires the Analysis ToolPak add-in to use the
NETWORKDAYS function.

If you consider holidays as not being business days you
have to create a list of those dates and include the
reference to that list in the NETWORKDAYS function.

Assume that list is in the range G1:G10.

Select the range of dates to conditional format.
Conditional formatting
Formula is: =AND(A1<TODAY()-12,NETWORKDAYS(A1,TODAY
(),G1:G10)10)

Select your format styles.
OK out

Biff

-----Original Message-----
Hi,
I'm trying to use the conditional formatting feature with
my Excel 2002
software for the first time, but I'm unsure of the values
needed.
Here's my question.

I want a range of values (dates to be more specific) to
be highlighted if
the date listed is older than 10 business days (or 12
calendar days).

I tried using the NOW, IF, and other fuctions, but didn't
come across what I
wanted to do.

Any help?
Thanks

.