Link to home
Start Free TrialLog in
Avatar of William C Johnson
William C JohnsonFlag for United States of America

asked on

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.
ASKER CERTIFIED SOLUTION
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.
Avatar of William C Johnson

ASKER

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