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

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

combining 2 dates into 1 cell
 

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" 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

combining 2 dates into 1 cell
 

Thanks for the feedback!

Andy.

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