Help with converting a file name into a usable date

[arekkusu03]

Hi All,

I'm having trouble converting a file name into a date.

in cell A1 which has formula =MID(CELL("filename"),FIND("[",CELL("filename"))+1,(FIND("]",CELL("filename"))-FIND("[",CELL("Filename"))-1))

This populates the file name "WC20130715.xlsx"

I would like to trim the file name to only be 20130715 (format is Year, Month, Day), then flip the date to be in the format of (Day, Month, Year) and make it a usable date so I can reference this cell to automatically populate dates for the rest of the week

Thank you

[humdingaling]

double post

[humdingaling]

from the above it sounds like you already have the answer?
from WC20130715.xlsx
assume name is in a1

=DATE((MID(a1,3,4)),(MID(a1,7,2)),(MID(a1,9,2))) ... gives 15-07-2013

[benishiryo]

hi arekkusu, another alternative:
=TEXT(MID(A1,3,8),"00-00-00")+0

format to date.

[arekkusu03]

Thank you humdingaling and benishiryo for your help and knowledge