The WORKDAY function is part of the analysis ToolPak add-in which is another
file. That's why you get the message.

Try this:

Create a defined named formula.
Goto InsertNameDefine
Name: WorkDate
Refers to: =WORKDAY(TODAY(),14)
OK

Then, use this formula in the conditional formatting:

=$AI$8WorkDate


--
Biff
Microsoft Excel MVP


"Mike" wrote in message
...
Hi Bob, thanks for the quick reply back. However, I get a message as soon
as
I try to save it 'You may not use references from other worksheets for
conditional fformatting criteria'

Any clues on this?
--
Regards
Mike


"Bob Phillips" wrote:

=$AI$8WORKDAY(TODAY(),14)

are you sure that you mean 14 working days, not 10?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Mike" wrote in message
...
Hi all, hope you can help. Excel 2003

I need to use conditional formatting on a cell if the date in this cell
is
14 working days Today(). I'm not sure where to place the
(AI1-Workday)
part within the formula bar

=TODAY()-$AI$814
--
Regards
Mike