combining 2 dates into 1 cell

[LT GLM]

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?

 

[Guest]

Hi

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

Andy.

 

[LT GLM]

Thank you!!!!! It worked!
--
LT GLM

Hi

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

Andy.

 

[Guest]

Thanks for the feedback!

Andy.

Thank you!!!!! It worked!