you’re able to use TEXT to format numbers that appear inside other text strings.

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

The TODAY function takes no arguments.

Excel formula: Convert date to text

it’s possible for you to format the value returned by TODAY with a datenumber format.

If you need current date and time, use…

Excel formula: Convert numbers to text

Excel TEXT function

Excel TODAY function