Note that the date is lost in the conversion: only the text for the month name remains.

To extract an abbreviated month name like “Jan”, “Feb”, etc.

This works because MONTH returns a number 1-12 that corresponds to the month name.

Excel formula: Get month from date

The values provided to CHOOSE can include references.

TEXT Function

The Excel TEXT function returns a number formatted as text.

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

Excel formula: Get day name from date

Excel formula: Convert date to text

Excel formula: Convert text to date

Excel MONTH function

Excel CHOOSE function

Excel TEXT function