Combine Cells With Text and a Formatted Date When you combine text with a date, you can format it by using the Text function. Without formatting, the date will appear as a number.
- Select the cell in which you want the combined data
- Type the formula, with text inside double quotes, and the date inside the TEXT function. For example:
="Today is " & TEXT(TODAY(),"dddd") - In the TEXT function, the date is the first argument, and the formatting is the second argument.
In this example, the TODAY function returns the current date. The "dddd" formats the date as the full weekday name.
