Forum Discussion
Solved
Excel formula to convert single number to year with less then/greater then
Hi all, Not sure what to name this topic, so sorry in advance for whatever convoluted name I came up with. Basically, I need to take a 2 digit (hexadecimal) year/month combo, i.e.: 81 = Janu...
So it's not a hexadecimal value but a combination of decimal and hexadecimal values.
Who invents such c***?
=IF((--LEFT(A1))<5,"202","201")&LEFT(A1)
=2018+(HEX2DEC(LEFT(A1))<5)*3
=HEX2DEC(RIGHT(A1))