How to Concatenate a Date with Text in Excel 2016
Learn how to concatenate a date with text and display dates in the correct format in Excel 2016. The TEXT function converts the date to display in the format of your choice. TEXT function allows you to display dates in different formats.