Hi Sara

One way
=--INT((SUBSTITUTE(SUBSTITUTE(A11,"[",""),"PM]","")))

This will return the serial number of the date.
Format the cell in whatever date format you wish to see the result
--
Regards
Roger Govier

Sara wrote:
This is what the cell currently looks like:

[10/01/09 11:30PM]

I would like the formula to return only: 10/01/09

Does anyone know what formula I should use? Any help would be greatly
appreciated.

Thanks!!

Sara