Date format conversion - help with formula

HI All,

I'm not too advanced a user. Im trying to get some data ready to import to my small business accounting system (from a previous one) and the date format is not correct.

The field is general format, and when i change to date it doesn't work.

I somehow need a formula that can take the old format and put into a correct date format, but I am struggling.

The date displays like this:

April 14, 2014
April 16, 2014
April 21, 2014
April 21, 2014
April 22, 2014
April 22, 2014
April 22, 2014
April 22, 2014

So thought I could work out a way to take each section after a comma and place in a new format (e.g. with no comma, just numbers). however, there is no comma between the month and the date.

There is 3 years of data (e.g. 2014, 2015, 2016).

Any help is hugely appreciated,
Neil

Hi, assuming your date text is in cell A1, this formula should convert it to a date value:

Please Login or Register  to view this content.

that worked perfectly NickyC - thank you very much!!