Cell equal to sheet name but change to date

[nickpavlov]

Hello,

Using this formula, =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256) I can have a cell equal the name of the sheet it is in.

But lets say the sheet is named 5.22.19, Can this formula be changed so that it converts that to a date?

Thanks,
Nick

[63falcondude]

Try this:

=SUBSTITUTE(MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256),".","/")+0

[nickpavlov]

Beautiful! Thank you AM63falcondude

[63falcondude]

You're welcome. Thanks for the rep!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.