Since H41 already contains a date--not a string, you don't need the datavalue()
function.

Double check H41 in both sheets...

Format that cell as general.

If it changes to a number, then it's really a date (and =datevalue() doesn't
work).

If it keeps looking like a date, then you need =datevalue().



Kim wrote:

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


--

Dave Peterson