Transforme date from "from Friday 4 to Sunday 6 January" to "2013-01-04" and "2013-01-06"

Hi,

I have the following problem:

I have dates in this format "from Friday 4 to Sunday 6 January 2013". I need to work on it to get the followings:

"2013-01-04" in one column
"2013-01-06" in another column

I was thinking to use the following formulas:

- LEFT, to get "from Friday 4"
- MID, to get "to Sunday 6 January 2013"
- eliminate somehow "from Friday" and "to Sunday"

I will remain with a cell with "4" and a cell with "6 January 2013"

- apply an IF formula, for example: IF 4<6, then add the same month of the 2nd cell to the 1st cell, otherwise pick the month after
- using another IF, for the years

I don't have any idea as to how I can do it.

Many thanks for your precious help in advance!

Sarah

Can you give an example where the dates span from one month to another, eg from 30th Jan to 4th Feb - how will this appear?

Pete