I have 52 worksheets which are titled "Week Ending 12-4-05" and so on.

I would like to extract the date (text) and enter it as a date (number) in a
cell.

Is there a function or some code that can be entered to do this?

Darrell

=--MID(MID(CELL("FILENAME",A1),FIND("]",CELL("FILENAME",A1))+1,32),13,34)

format as date, if you only want a text representation of the date

=MID(MID(CELL("FILENAME",A1),FIND("]",CELL("FILENAME",A1))+1,32),13,34)



--

Regards,

Peo Sjoblom

"Dr. Darrell" wrote in message
...
I have 52 worksheets which are titled "Week Ending 12-4-05" and so on.

I would like to extract the date (text) and enter it as a date (number) in
a
cell.

Is there a function or some code that can be entered to do this?

Darrell

Thank you.

"Peo Sjoblom" wrote:

=--MID(MID(CELL("FILENAME",A1),FIND("]",CELL("FILENAME",A1))+1,32),13,34)

format as date, if you only want a text representation of the date

=MID(MID(CELL("FILENAME",A1),FIND("]",CELL("FILENAME",A1))+1,32),13,34)



--

Regards,

Peo Sjoblom

"Dr. Darrell" wrote in message
...
I have 52 worksheets which are titled "Week Ending 12-4-05" and so on.

I would like to extract the date (text) and enter it as a date (number) in
a
cell.

Is there a function or some code that can be entered to do this?

Darrell