So in one cell I'm trying to have a combination of formula and text that would output something like this: Today's Date: 9/21/2020
I've written the formula as: ="Today's Date: "&TODAY()
With this though, I keep getting an output for the date in a number format and am not sure how to format the TODAY() formula to the Short Date format.
Any help on this would be great. Thanks!
Bookmarks