I'm trying to get just the filename and i used this formula, =MID(CELL("filename",E30),90,13). the formula works fine until there's more characters then it doesn't capture what is need and i would need to change the "13" to a 14 or 15 depending on how many more characters. I know the offset formula will work but it's a tricky formula & i still haven't gotten it down.

S:\FinancialStatements\FinancialStatements\Route66\2019\02February2019[GLDetail-February2019.xlsx]Recon |

<tbody>

</tbody>

Above is the file name. i'm just trying to capture the month and year of the file and like i said the mid formula works until it's the next month then i'll need to change the mid formula. what's the formula for offset so i don't need to change the formula every month? Thanks.