We help IT Professionals succeed at work.

How to write an Excel formula containing text and the Today function?

I want a formula that yields the words "As of" plus today's date.
Comment
Watch Question

Software Tead Lead / Business Analyst / System Analyst / Data Engineer
CERTIFIED EXPERT
Commented:
something like this?

="As of " & TEXT( TODAY(), "MM/DD/YYYY")

Open in new window

Rob HensonFinance Analyst
CERTIFIED EXPERT

Commented:
You could just apply a Custom format to the cell containing the date:

Formula = TODAY()

Format  "As of " mm/dd/yyyy   including the double quotes

The cell can then still be used in formulas as it will still be a number whereas adding the text in the cell converts it to text so any formulas that refer to it will have to allow for the text.

Author

Commented:
This is just what I was looking for.  I simply had the right idea but the wrong syntax.  Thank you.