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

Hi

Try something like this:
=TEXT(A1,"dd/mm/yy")&" . . . "&TEXT(A2,"dd/mm/yy")

Andy.

"LT GLM" wrote in message
...
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