Click the Text2 box and nest the TEXT function from the Text category.

[teeks88]

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.

How do I nest the TEXT function from the Text category?

[#2]

@teeks88 

What is Text2 box?

You may type as

with selecting any function to continue with if you'd like to select it from ribbon menu.