In a new column you can use the MID function to only select the data after the day of week. Unfortunately this formula will vary based on the number of letters in said day of week
For your example in the OP you would use =MID(A1,8,20), which would return 2 November 2017. You can then use the...