View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LT GLM
 
Posts: n/a
Default combining 2 dates into 1 cell

This what I would like to see in a cell A3. How do I put it into a formula?
ex:
A1 displays a date "2/1/06"
A2 has function "date" which displays the current date "3/31/06"

This is how I would like A3 to read: 2/1/06..3/31/06

Any suggestions?
--
LT GLM