Extract date from cell

[Sunline]

Hello all , i am wanting to know if i could get a simple function to extract the date portion of cell A1 and return the answer as given in cell B1 .
Thanks .

Excel Workbook
	A	B
1	9 Jan 2005 TAUP	9/01/2005
2	12 Jan 2005 TAUR	12/01/2005
3	5 Feb 2005 TERA	5/02/2005
4	5 Feb 2005 AWAP	5/02/2005
5	19 Feb 2005 MATA	19/02/2005
6	19 Feb 2005 TREN	19/02/2005
7	3 Mar 2005 HAST	3/03/2005
8	28 Mar 2005 ELLE	28/03/2005
Sheet1

 

[VoG]

Try

=DATEVALUE(LEFT(A1,LEN(A1)-5))

 

[Sunline]

Works great , thanks VoG .