Concatenate formula for dates

[willow1985]

I have 2 columns (K and L) with the dates in the format: 08/27/2019 & 08/29/2019.

I want to use a Concatenate formula to have the end result showing: Aug 27 - Aug 29.
The formula I wrote is as follows:

=CONCATENATE(TEXT(K3,"[$-409]mmm d;@")," - ",(TEXT(L3,"[$-409]mmm d;@")))

However this formula is producing this as the result and I do not understand why:

08/27/2019 - 08/29/2019

I would also like to have the formula return a blank result if K or L are blank.

Hope you guys can help me on this.

Thank you

Carla

 

[JoeMo]

Sheet1

	K	L	M
Aug 27-Aug 29

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:68px;"><col style="width:68px;"><col style="width:95px;"></colgroup><tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]1[/TD]
[TD="align: right"]8/27/2019[/TD]
[TD="align: right"]8/29/2019[/TD]

</tbody>

Spreadsheet Formulas

Cell Formula M1 ==IF(COUNT(K1:L1)<>2,"",TEXT(K1,"mmm dd")&"-"&TEXT(L1,"mmm dd")) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

 

[SpillerBD]

=TEXT(K3,"mmm dd") & " - " & TEXT(L3,"mmm dd")

 

[willow1985]

This works perfectly, Thank you!

 

[willow1985]

This formula is a lot simpler. Thank you very much!