Help need for extracting the Date field

[komarag]

I have a column that contains the following values....in Character format...
6/6/2011 8:00:00 AM

I want a extract the date portion from this field and place it in a separate field with Date Format so that I can group the data by Month.

[Jesse]

=DATEVALUE(LEFT(A1,FIND(" ",A1)))

This should do the trick.

Jesse

[komarag]

Need generic formula for that Input format...I do not want to input the date value into this formula....

attached a sample file

[Jesse]

DATEVALUE is a function, converts text based dates to Excel dates.

Jesse

[komarag]

I understand Jesse..Please find the sample file attached.

[Jesse]

What is it that you want the data to look like for output, just the month number or name?

Jesse