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
=DATE(Date#(Date,'MMMM D, YYYY'),'MMMM D YYYY')
It works !!
Thank you very much
Retrieving data ...