Conversion to month/year for pivot

[John Schroeder]

I have a large data file that contains a column of data that refers to a month and year in the following format YYYYMM. Trying to covert and strip out month (MM) into a data value for a pivot table and having issues. I have seen some code decifier some data, but cant seem to extract it for my purposes. Any help appreciated

 

[R Pelle]

Is this what you're looking for?

Excel Workbook
	A	B	C	D	E
22	YYYYMM	AMOUNT	MM	YY	Date
23	199902	500	02	1999	01/02/1999
24	200104	2500	04	2001	01/04/2001
25	200611	1234	11	2006	01/11/2006
26	201008	4444	08	2010	01/08/2010
27	201008	4500	08	2010	01/08/2010
28	201008	3501	08	2010	01/08/2010
Sheet1

Excel 2010

Cell Formulas
Range	Formula
C23	=RIGHT(A23,2)
D23	=LEFT(A23,4)
E23	=DATE(D23,C23,1)

Excel Workbook
	H	I	J
30	Sum of AMOUNT
31	YY	MM	Total
32	1999	02	500
33	2001	04	2500
34	2006	11	1234
35	2010	08	12445
36	Grand Total		16679
Sheet1

Excel 2010

 

[John Schroeder]

Perfect. The other formulas that I have seen looked more complicated to adapt. Thanks.