Hey John,

That does the trick.

Thank you. My thanks to all of you.

-Minitman



On 6 Dec 2005 13:46:17 -0800, "John Michl" wrote:

I'd use this.

=DATE(MID(CELL("filename"),FIND("-",CELL("filename"))-4,4),MID(CELL("filename"),FIND("-",CELL("filename"))+1,2),1)

The final "1" in the formula indicates day one. You can format the
result to show the date in any way desired.

- John
www.JohnMichl.com