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

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,

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

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

Dave, thanks for sticking with me.

This issue came up when I combined an existing file (two sheets) into a
another file (becoming sheets 12 & 13). I zeroed all the newly affected
cells and started from the beginning using your suggestions. Bottom line it
appears to work correctly now so I've backed slowly away from the larger
file. It appears I got myself into a 'been there - done that'
troubleshooting circle.

Thanks again for your patience.

Kim

"Dave Peterson" wrote:

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