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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do i combine 2 cells contain date in one cell, (https://www.excelbanter.com/excel-worksheet-functions/198381-how-do-i-combine-2-cells-contain-date-one-cell.html)

Bintaro645

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

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

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

Try,

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

Mike

"Bintaro645" wrote:

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

Gary Brown[_4_]

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

=TEXT(A1,"mmmm yy") & " - " & TEXT(B1,"mmmm yy")
--
Hope this helps.
Thanks in advance for your feedback.
Gary Brown

"Bintaro645" wrote:

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

All times are GMT +1. The time now is 12:11 AM.