Forum Discussion
Solved
The date keeps breaking my formulas.
I have a formula to make a unique unidentifiable code for each person, but the date column keeps breaking the formula and doing weird things. It's a basic formula =RIGHT(I2,2)&RIGHT(K2,4)&RIGHT(L2...
ShaneATV Dates in Excel are actually stored as sequential numbers, where 1 = 01-Jan-1900, 2 = 02-Jan-1900, etc. The date you have entered in cell L2 (12-Jan-1984) is equivalent to the number 30693 in Excel, which is why RIGHT(L2,2) returns 93. Try using the TEXT function for that cell to return the 2-digit year formatted as "YY":
=RIGHT(I2,2)&RIGHT(K2,4)&TEXT(L2,"YY")&LEFT(N2,1)
Thank you all... Much appreciated 🙂