View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Patrick Simonds
 
Posts: n/a
Default Using cell contents within a formula

On my worksheet is a date column (formatted DDD DD MMM YY), I have a cell
which I want a formula which would incorporate the date from cell A1 and
A14, the result should like something like this:

01 Jan 06 - 14 Jan 06


Cell A1 displays Sun 01 Jan 06 and cell A14 displays Sat 14 Jan 06. Is it
possible to do what I am trying?