In Excel, I'm trying to have a cell look something like:
by no later than August 27, 2012
When I try to concatenate a string with a DATE, for example:
="by no later than " & DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()))
I get an output like this:
by no later than 41118
How can I get a date to show up instead of an integer?