View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dick Frederick Dick Frederick is offline
external usenet poster
 
Posts: 2
Default Help With DATEVALUE

I am sure this has come up before. I wish to return a date in cell (say) B1
to the datevalue in (say) cell B2. Yes, I can type the date in the formula
using quotes, but what I want to do is reverence (say) cell B1 in the
formula and have it return the datevalue. Can anyone tell me how to effect
this? I don't mind using a workaround, but I would not like to use a macro
unless necessary.

TIA,

Dick Frederick