Extracting date from text cell

[Detectiveclem]

Can anyone assist me with the formula to extract the date which is shown at the end of a string of text in a cell.

Each cell has differing lengthts of text and some cells are completely blank.

The date is at the end of the string of text and is displayed like this 03/04/2018 (DD/MM/YYYY). I purely want the date extracted into its own cell and where the target cell is blank not to show an error message.

Help on this would be much appeciated.

Thanks Paul

 

[wideboydixon]

Book1
	A	B
1	Today is 18/04/2018	April 18, 2018
2
3	Yesterday was 17/04/2018	April 17, 2018
4	Tomorrow will be 19/04/2018	April 19, 2018
Sheet1

Cell Formulas
Range	Formula
B1	=IF($A1="","",DATEVALUE(RIGHT($A1,10)))

Assuming it's always the last 10 characters of the cell contents.

WBD

 

[Detectiveclem]

Thank you WBD, works perfectly. I have been playing around with different formulas for hours, so thank you for solving this.

Paul

 

[wideboydixon]

No problem. Greetings from the Northern Powerhouse

WBD