give an example of the format of the date

mmddyyyy
yyyymmdd

--


Gary Keramidas
Excel 2003


"Fred Smith" wrote in message
...
I have a text in a cell which ends with a date. I would like to extract the
date. I tried the following:

Dim ReportDate As Date
ReportDate = Range(Right("L3",8)) - 1

but got a type mismatch error.

How do I extract the last 8 characters of a cell into a Date variable in
VBA?

Thanks,
Fred