The formula will work if the text starts with a day followed by a comma
followed by a single space. Which is what your example shows.
--
Gary''s Student - gsnu200793


"Sarah (OGI)" wrote:

Thanks for your prompt response, but I'm getting a #VALUE! result. Any ideas
why this might be?

"Gary''s Student" wrote:

With your value in A1 use:

=DATEVALUE(RIGHT(A1,LEN(A1)-FIND(" ",A1,1)))

and format it as you choose
--
Gary''s Student - gsnu200793


"Sarah (OGI)" wrote:

I've received a report whereby column A shows a list of dates.
Unfortunately, it seems that the date is written in a 'general' format and
looks like this:

Sunday, June 15, 2008

Is there an easy way to convert this into a date format, i.e. dd/mm/yy?