formula effects all dates in rest of worksheet

V

VIT

Hello!
We change a date in one cell and all the other cells in sheet get
unrecognizable. The cell we change has this formula =SUM(U14+28) and when we
change the 28 to a 42 the reset of the cells go to this symbol...#NAME?
Any ideas why this is happening, and are there any options we need to check.

we are using Office 2003 on Windows XP SP2.

Thanks,
CC
 
J

JE McGimpsey

What are the formulae in the cells that display the #NAME! error?

(Note that your SUM() is redundant - it just adds an unnecessary
function call. Better:

=U14+28

).
 
V

VIT

Thanks for the reply!

Here are some examples:
=WORKDAY(L21,-L$13,$A46:$A61)
=WORKDAY(L35,-L$13,$A46:$A61)
=WORKDAY(Q41,-Q$13,$A46:$A61)

hope that helps you out some....let me know if you need any more information!

Thanks,
CC
 
G

Gord Dibben

Maybe this........?

WORKDAY is an ATP function.

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.


Gord Dibben MS Excel MVP
 
Top