Different Date Formats

[Jewnaa]

Dear Excel Geniuses

Hi

I have 20K+ rows containing different date formats. I need your help to convert in single format ie. UK/US.

Regards
Jewnaa

 

[Jewnaa]

this is the real issue, some one in past typed multiple date formats in workbooks. Now I have to change all to UK format.

 

[Andrew Poulsom]

Are those entries in column A text or serial dates formatted as mmmm yyyy?

 

[Jewnaa]

serial dates, mmmm yyyy

 

[Andrew Poulsom]

Formula in C2 copied down:

Excel 2010
	A	B	C
1	Target Month	Target Achieved Date
2	June 2001	06/02/2001	02 Jun 2001
3	June 2001	06/07/2001	07 Jun 2001
4	July 2001	08/07/2001	08 Jul 2001
Sheet1

Cell Formulas
Range	Formula
C2	=IF(MONTH(A2)=MONTH(B2),B2,DATE(YEAR(B2),DAY(B2),MONTH(B2)))

 

[Jewnaa]

Working.........................

I am really thankful you sir.

All my 20k+ entries are in required format.

Thanks again for your guidance.