Find word in a cell range and return a date

[kabootar]

Hi - I have a table where in the comments column will have the word "fix" and followed by a date - i need to pull out the date where the cell includes the word "Fix".

However, the word fix could be in all capitals or or lower case etc and in some cases it could have a . or : after the word fix. Also it could say "Fix del date" followed by the date in "DD/MM" format.

Is there a way of finding the word in the cell and then copying the date to the next available column? as i can do a loop and find the word within the cell ranges but cant seem to get the date to copy across

I have attached an image of the example table

Any help will be appreciated.

 

[Sufiyan97]

Try

Book1
	O	P	Q	R
1
2		fix 10/01	10/01
3		Fix: 09/01	09/01
4		FIX. 11/01	11/01
5		Fix. Mpo
6
7
Sheet1

Cell Formulas
Range	Formula
Q2:Q5	Q2	=IFERROR(TRIM(MID(P2,SEARCH("Fix",P2)+4,6))+0,"")