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
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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks