How do i combine 2 cells contain date in one cell,

[Bintaro645]

I have two cells contain date A1 : 39508 (after formated = march 08) and
B1:39539 (after Formated = April 08) How do i combine this Two cells to C1 if
I need the result should be "March 08 - April 08".

 

[Mike H]

Try,

=TEXT(A1,"dd/mm/yyyy") & "-" & TEXT(B1,"dd/mm/yyyy")

Mike

 

[Gary Brown]

=TEXT(A1,"mmmm yy") & " - " & TEXT(B1,"mmmm yy")