Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#VALUE!
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. |