Convert Month Name to a Date

[brf10043]

I'm sure that this really easy, but if I'm given a month name such as "February" in an excel file and need to convert it to a Date value such as 'MM/DD/YYYY', how would I do that?

[brf10043 · Accepted solution]

I just worked this out.  I discovered Date#

[#3]

is it just February or is it an entire date like Feb 03 2016

=date(date#('Feb 03 2016', 'MMM DD YYYY'), 'MM/DD/YYYY')