I'm working on a spreadsheet where I have the text 'Saturday 4 October 2014'. I want to convert this into an actual date.
Can anyone help?

Regards,
Tim