Hi

What do you get, when you enter the formula
=DateFrom
into any free cell. I'm afraid it too will be "#NAME". When yes, then check
your name definition - probably it's corrupted (p.e. you deleted the cell
N9, or row/column with it, accidentally).



--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"Christine" wrote in message
...
Thanks for responding, David. No, there isn't a typo in the formula - it
is
=IF(DateFrom<"",WORKDAY(DateFrom,-7),"")

The error I'm getting says "#NAME?".

As mentioned, I do have the Analysis tool pack installed. I've also tryed
ticked Tools/Options/Calculation/"Accept labels in formulas". I've
verified
that the label "DateFrom" exists as well.


"David Biddulph" wrote:

Nothing wrong with the syntax.

It's always easier for people to help you if you tell us the symptoms,
rather than just "It doesn't work". What value does the formula give
you?
Are you sure that you haven't got a typo? (For example, in your message
you
had DateForm once and DateFrom twice).

What do you get if you put =DateFrom into a spare cell? What do you get
if
you put =N9? What do you get if you put =WORKDAY(DateFrom,-7)?

Are you sure you've got the calculation mode set to automatic? What
happens
if you do an F9?
--
David Biddulph

"Christine" wrote in message
...
My formula doesn't produce an error, but it doesn't work either! Can
someone
help?

DateFrom is the name I've applied to cell N9.

In cell G23 I want to show DateForm - 7 working days, so I've entered
this
formula in the cell:
=IF(DateFrom<"",WORKDAY(DateFrom,-7),"")

Can someome tell me what's is wrong with this syntax? (Analysis
Toolpack
is
installed.)

Many thanks!