Dave,

Thanks you for your response. It appears I have created a situation that
should not work --

In it's simplest form "=datevalue(h41)" = 38732 on sheet2 and "#VALUE!" on
sheet1. H41 contains 1/15/2006 formatted at "*3/14/2001". on both sheets.

Still puzzled.........

Thanks again, Kim


"Dave Peterson" wrote:

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