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.
Microsoft ExcelMicrosoft Office
Last Comment
William C Johnson
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
This is just what I was looking for. I simply had the right idea but the wrong syntax. Thank you.
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.