6GN3839883
6G = NEVER CHANGES
N = MONTH 1-9 JAN - SEP, O - D OCT - DEC
3 = YEAR
39883 = IS UNIQUE TO THE PRODUCT
I WANT TO SET UP A FORMULA THAT WILL AUTOMATICALLY TELL ME IF THE PRODUCT IS
WITHIN WARRANTY.
IT CAN NOT BE ANY OLDER THAN 2 YEARS, I.E. 6GD901234 (6G DEC 1999) WOULD BE
TO OLD
SO IT HAS TO SHOW THAT IS WITHIN SAY 6G23????? AND 6G15?????.
I HAVE TRIED USING 'IF' BUT I CAN NOT SEEM TO GET THE FORMULA RIGHT.
IS THERE A FORMULA I CAN USE?