I need help with a formula that combines text and a date.
="For Week Ending "&TODAY()-WEEKDAY(TODAY()-15)
It should look like:
For Week Ending 3/8/15
My problem is that it's converting the date to a numeric value. Instead of 3/8/15 it's returning 42071. And date formatting doesn't change it.
I'd rather not split this into two cells. Is it possible to force the date formatting?
Thanks!!
Bookmarks