Hello all,
I have a cell that is automatically named after its sheet name with the following formula: =MID(CELL("filename";A1);FIND("]";CELL("filename";A1))+1;255)
The sheet name is named after a date like "vr-2-sep".
However excel doesn't recognize it as a date. So i would like to copy the result into another cell and format it as a date value so i can link it with other date values somewhere else in the worksheet.
hope someone has a fix for this, thanks
I have a cell that is automatically named after its sheet name with the following formula: =MID(CELL("filename";A1);FIND("]";CELL("filename";A1))+1;255)
The sheet name is named after a date like "vr-2-sep".
However excel doesn't recognize it as a date. So i would like to copy the result into another cell and format it as a date value so i can link it with other date values somewhere else in the worksheet.
hope someone has a fix for this, thanks