Use CONCAT to display a sentence about the current date.

1. Click cell A22 on the Aging Detail sheet and start a CONCAT formula.
2. Type Today is with a space after the word is for the Text1 argument.
3. Click the Text2 box and nest the TEXT function from the Text category.
4. Type today() for the Value argument. The equals sign is not necessary when the function is used as an argument.
5. Click the Format_text box and type mmmm d, yyy. This format spells out the month, uses four digits for the year, and shows the date without leading zeros