Home |
Search |
Today's Posts |
#1
|
|||
|
|||
excel formula
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do figure excel formula out? | Excel Discussion (Misc queries) | |||
How to I use ** without Excel thinking I want to type a formula? | Excel Discussion (Misc queries) | |||
Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) | |||
Preserve Excel formula entry | Excel Discussion (Misc queries) |