How to combine string with DATE ()?

Question

In Excel, I try to make the cell look something like this:

by no later than August 27, 2012

When I try to combine a string with a DATE , for example:

="by no later than " & DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()))

I get the output as follows:

by no later than 41118

How can I get a date to display instead of an integer?

Answer 1

DATE building a date stamp. You need to convert this to a string. See this question on how to do this:

• Convert Excel to String Format

It will look something like this:

 =TEXT(DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())), "DD/MM/YYYY hh:mm:ss") 

Answer 2

You don’t need the DATE function for today's date at all, you can only use

="by no later than "&TEXT(TODAY(),"mmmm d, yyyy")

Answer 3

If you format the cell containing your number (41118) as Date , you will get exactly 27.8.2012. Plain!