date function to convert number to mmm & combine with another cell value

[RAJESH1960]

Hello Everyone,
I wanted to know how to change the format of the month from figure(10) to word (mmm) after using the & function to combine. The date is in dd-mm-yyyy format

 

[Fluff]

You need to remove the MONTH function from the formula.

 

[RAJESH1960]

You need to remove the MONTH function from the formula.

Thanks Fluff. Been trying since 4 hours...?

 

[Fluff]

You're welcome & thanks for the feedback.