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?
Select a blank cell you will output the concatenation result, and enter the formula =CONCATENATE(TEXT(A2, "yyyy-mm-dd")," ", B2) ( A2 is the cell with date you will concatenate, and B2 is another cell you will concatenate) into it, and press the Enter key.
To Concatenate Dates in Excel, first, we need to convert the cells which contain Date into Text format using the TEXT function, and there we will choose the format of the date that we want to keep in text format. Insert CONCATENATE function in a cell and right after starting the TEXT function.
Combine data using the CONCAT function Select the cell where you want to put the combined data. Type =CONCAT(. Select the cell you want to combine first. Use commas to separate the cells you are combining and use quotation marks to add spaces, commas, or other text.
DATE
builds a date timestamp. You need to convert that to a string. See this question for how to do so:
It would look something like this:
=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())), "DD/MM/YYYY hh:mm:ss")
You don't really need DATE function at all for today's date, you could use just
="by no later than "&TEXT(TODAY(),"mmmm d, yyyy")
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With