How to extract a WorkSheet Name and have it then formatted as a date field.
Posted on 2011-03-03
Hello again Experts, I need your help.
I want to extract a WorkSheet Name (eg. 02-24-2011) into a cell and have it then formatted as a date field (eg. mm/dd/yyyy).
I use this formula in the cell to extract the WorkSheet Name:
However, even though I format the cell to be (mm/dd/yyyy), the result is still 02-24-2011 and not recognized as a date.
Is there anything I can do to work around this?