Handle this date "June 1, 2014"

[#1]

Hello,

I have a date format like this:

"June 1, 2014"   (date is a string and comma is inside)

I have tried this function but it doesn't work:

Date#(Date,'MMMM D YYYY')

Could anyone help me?

My best regards

[ashfaq_haseeb · Accepted solution]

TRY BELOW

=DATE(Date#(Date,'MMMM D, YYYY'),'MMMM D YYYY')

Regards

ASHFAQ

[#3]

It works !!

Thank you very much