Hi,
I want to create a way in Excel to convert a regular date (say “09/17/07”) into a code that will go on our products for our clients to decode visually, using a format such as:
M=1
U=2
R=3
K=4
Y=5
C=6
L=7
O=8
W=9
N=0
So, “09/17/07” would be recoded to be “NWMLNL”.
I’m sure this is possible, and probably a lot simpler that I imagine. Any help would be greatly appreciated. Thanks in advance.