#VALUE!
Maybe the user is adding spaces before the date to make the column align and
look pretty!<g
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Glenn" wrote in message
...
We have a spreadsheet with the following formula in a column of cells:
=B7+54-$E$3+K7
Column B contains a date, E3 contains the current date and K7 contains a
number of days. When a date is entered in column B, it calculates a new
value
and deposits that value (a number of days) into the cell with the formula.
This works for every user but one. When he enters a date in a cell in
column
B, the cell with the formula displays #VALUE! instead of a number. I have
not
been able to figure out what is different about this user and any help
would
be appreciated.
Thanks.
|