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
|