KuraiChikara
Board Regular
- Joined
- Nov 16, 2016
- Messages
- 111
- 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
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Unique Value Formula[/TD]
[TD]Name[/TD]
[TD]Duty[/TD]
[TD]Date[/TD]
[/TR]
[TR]
[TD]John|Lawn|43578[/TD]
[TD]John[/TD]
[TD]Lawn[/TD]
[TD]04/23/2019[/TD]
[/TR]
[TR]
[TD]John|Lawn|43577[/TD]
[TD]John[/TD]
[TD]Lawn[/TD]
[TD]04/22/2019[/TD]
[/TR]
</tbody>[/TABLE]
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
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Unique Value Formula[/TD]
[TD]Name[/TD]
[TD]Duty[/TD]
[TD]Date[/TD]
[/TR]
[TR]
[TD]John|Lawn|43578[/TD]
[TD]John[/TD]
[TD]Lawn[/TD]
[TD]04/23/2019[/TD]
[/TR]
[TR]
[TD]John|Lawn|43577[/TD]
[TD]John[/TD]
[TD]Lawn[/TD]
[TD]04/22/2019[/TD]
[/TR]
</tbody>[/TABLE]