Amend Symbol & With Date Formats

KuraiChikara

Board Regular
Joined
Nov 16, 2016
Messages
94
Office Version
2013
Platform
Windows
Is it possible to use the amend symbol (&) with a date and keep the date format?
The purpose would be to create a unique identifier for Vlookups but the result is not user friendly.

Example:
A user could show up multiple times, their duties could show up multiple times, the only thing that would differentiate it would be the date.

If I wanted to create a unique value to perform a VLOOKUP, I would do the following with the pipe symbol (|) to separate the values but I don't like the end result of the date:

Putting in this formula: =A2&"|"&B2&"|"&C2
Yields this result: John|Lawn|43578

Is it possible to get the date shown as a date? My end goal would be this John|Lawn|04/23/2019

Unique Value FormulaNameDutyDate
John|Lawn|43578JohnLawn04/23/2019
John|Lawn|43577JohnLawn04/22/2019

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Scott T

Well-known Member
Joined
Dec 14, 2016
Messages
2,610
Office Version
365, 2016
Platform
Windows
Code:
=A2&"|"&B2&"|"&TEXT(C2,"mm/dd/yyyy")
Note that even though it looks like a date it is actually text.
 

Watch MrExcel Video

Forum statistics

Threads
1,090,453
Messages
5,414,633
Members
403,538
Latest member
indiemusicboy

This Week's Hot Topics

Top