"Today" formula

P

Portuga

I use the formula in D2 cell:
=TODAY()-C2
C2=10/06/2004

In my document, this formula gives me the value I want (Case age=167)
no problem there, but when I send it to another user, that user has a
error message (#VALUE!) on cell d2.

Even when I type the "today" formula again in the user document, i
still comes with the same error. (Both cells in both documents have th
same formating)

Same version of excel. (2002)

Help
 
F

Frank Kabel

Hi
what does the formula
=ISNUMBER(C2)
return on the other PC.
I would suspect C2 is NOT a rela date value but a 'Text' value
 
P

Portuga

Thanks Frank.

I managed to find the problem.

I needed to instal the "analysis tool pack" fom the "Add-ins" options
from the "tools" menu.

All is working now!
 
G

Gord Dibben

That's a pretty strange fix.

ATP has nothing to do with the TODAY() Function

Besides which, if you were using a Function from the ATP and ATP was not
loaded, you should be getting the #NAME? error, not #VALUE!

Gord Dibben Excel MVP
 
Top