DATEVALUE works on one sheet, not another
I'd look at the cells (H41 and summary!I1 in your example).
Remember, those cells shouldn't contain a date--they should contain text that
look like dates.
Kim wrote:
I have a datevalue formula - "=DATEVALUE(H41)-DATEVALUE(Summary!$I$1)" that
works on one worksheet but not another in same file. Changing arguements in
either 'datevalue' works fine. Cut and paste to another worksheet = #VALUE!.
I have Analysis ToolPak loaded. Been scratching my head on this one for a
while.
Thanks for any help or feedback!
Kim
--
Dave Peterson
|