View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson
 
Posts: n/a
Default 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