Worksheet name using =cell... formula

Hi,

I have tried using a function "RIGHT(TRIM(RIGHT(SUBSTITUTE(CELL("filename";H1);"_";REPT(" ";20));20));2)" to extract the 2 numbers from the worksheet name. It works and shows in row1 as a number but I want as well it to show as a month name (on row1) and change the month name depending on what last 2 digits i write in the worksheet name.

Is it possible to do without using VBA ?

Thanks for any help !

Thanks bro, works like magic

BTW what does "1" represents after date (... ?