Similarly, the TEXT function allows you to convert a date or time into text in a preferred format.

you’re free to use theTEXT functionto convert dates or any numeric value to a fixed text format.

Also, seeExcel custom number formats.

Excel formula: Join date and text

in a text string with the number format of your choice.

Excel formula: Get day name from date

Excel formula: Get month name from date

Excel formula: Convert text to date

Excel TEXT function