Date conversion
I'm wanting to convert a date to a related symbol string.
Example: 7/16/21 to "210716"
12/17/21 to "212217"
Note that when month has a single digit, a "0" must be added before it in the string.
Can't figure out how to do it using Excel functions. Any ideas would be greatly appreciated.
|