Dates Format

[Dennis]

I have three cells.

The first cell has a date
The second cell has another date

I want to combine the two dates into one cell so it shows
DD/MM/YY - DD/MM/YY using the & function, but when I do
this, the second date is converted into the other format
of date (ie. 364346)

Is there any way to combine the two cells and keep the
date format?

 

[Peo Sjoblom]

Use the TEXT function

=TEXT(A1,"dd/mm/yy")&" - "&TEXT(A2,"dd/mm/yy")

 

[SidBord]

Perhaps you can create a text string with something like:

=Text(A1,"DD/MM/YY") & " - " & Text(B1,"DD/MM/YY")