Forum Discussion
James Morgan
Dec 15, 2016Copper Contributor
completing statements in Excel
I have built an excel sheet that creates commands that I need to run in my software to make updates. I have cells 1 that contain information (column b) that is updated according to the job.
A B
1 Name John Smith
2 Address 123 Main St
3 City Anytown, Tx
4 Date 12/15/2016
With B4 coded as =today() so that it will reflect the current date.
I have my commands that utilize the information that is input above and incorporates them into the command
="My neighbor "&B1&" moved into "&B2&", "&B3&" on "&B4&""
So the result would be
My neighbor John Smith moved into 123 Main St, Anytown, Tx on 42719
My problem is that I cannot get the date from cell B4 to reflect correctly in the end of my statement. See how 12/15/2016 converts to 42719. Can someone help me figure out how to get the end of my statement to read “on 12/15/2016”
Thanks
- Lutz GebhardtCopper Contributor
Hallo James,
just convert your date into text.
="my neighbor "&B1&" moved into "&B2&", "&B3&" on "&TEXT(B4,"MM/DD/YY")&""
Regards, Lutz