Forum Discussion
Solved
Alpha-Numeric serial numbers to dates
Hello, I am looking to make a formula to convert a serial number, for example AC21BDA123 into a date (month and year). The above serial number would be year as the 1st and 2nd number (2...
This works, thank you! I see how we get the year by using the two numbers with the date function, but how do you use the code function to get the month?
CODE returns the ASCII/ANSI code of a character.
The ASCII code of "A" is 65, that of "B" is 66 etc.
If we subtract 64 from that, we get the month number 1, 2, etc.
- That's a creative way I didn't think about when trying to get the month to work, thank you for showing me!