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