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

Hi

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

Andy.

"LT GLM" <[email protected]> wrote in message
news:[email protected]...
> 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

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


"Andy" wrote:

> Hi
>
> Try something like this:
> =TEXT(A1,"dd/mm/yy")&" . . . "&TEXT(A2,"dd/mm/yy")
>
> Andy.
>
> "LT GLM" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>

Thanks for the feedback!

Andy.

"LT GLM" <[email protected]> wrote in message
news:[email protected]...
> Thank you!!!!! It worked!
> --
> LT GLM
>
>
> "Andy" wrote:
>
>> Hi
>>
>> Try something like this:
>> =TEXT(A1,"dd/mm/yy")&" . . . "&TEXT(A2,"dd/mm/yy")
>>
>> Andy.
>>
>> "LT GLM" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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
>>
>>
>>