This will only work if your date and time is formatted as text.

If you are just trying to extract the date only do this:

=E5

and then Format CellsDate[3/14/2001] (or however you want the date
displayed)


--
mphell0
------------------------------------------------------------------------
mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153
View this thread: http://www.excelforum.com/showthread...hreadid=501062