Hello,
I need help with a formula to add 1 to an alphanumeric cell. Cell A1 uses the formula: =RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1))) to make A1 the same as the worksheet name. I want a formula for L1 to be A1 + 1. I have 16 weeks of golf league...