Solved: Dates in text String

[koala]

Can anyone help with this.

I have start date in Column A and finish date in Column B.

I wish to join them in a text string, but cant work out how to get the date format correct.

I have attached a small spreadsheet which shows my requirements, as it is easier to see it than for me to describe it.

cheers
Koala

[p45cal]

=TEXT(A3,"dd mmm yyyy") & " to " & TEXT(B3,"dd mmm yyyy")

[koala]

I just worked it out.

Attached is the result in case anyone else ever wants to know.

cheers
Koala

[koala]

Thanks p45cal, i worked it out but you beat me to the post

Thanks for helping

cheers
Koala

[p45cal]

you could simplify your
&" "&"to"&" "&
to
& " to " &