I need to concatenate a text message "Start Date: " and a reference field that has the date in mm/dd/yyyy format. How do I get Excel to recognize the reference to the date as a date and not just a number "53422"?
I need to concatenate a text message "Start Date: " and a reference field that has the date in mm/dd/yyyy format. How do I get Excel to recognize the reference to the date as a date and not just a number "53422"?
use text()
"start date: "&text(a1,"mm/dd/yyyy")
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Try ="start Date:"&text(A1,"mm/dd/yyyy")
Thank you very much for your solution. As a follow-up, how do I format the "Start Date: " as Bold and the date itself as normal.
you cant with a function
You could use a custom date format. Select the cells that the "concatenated date" will appear and format the cells as: "Start Date: " When you enter a reference to a date the date will be preceded by Start Date:
This is done by: right clicking the selected cells, choose Format Cells, click on Date, Custom and enter "Start Date: " in the field.
Now you can either enter the date directly or enter the cell reference to the cell with a date and the result will be Start Date: <your date>
This has an advantage that the dates are still dates and not text that looks like a date.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks