Date Format - CONCATENATE

The image below describes what I am asking.

I am using Microsoft® Excel® 2016 MSO (Version 2201 Build 16.0.14827.20028) 32-bit