Pivot Table Sorting Dates Out of Order

[errollflynn]

Hello,

I have a data table with the start date and another column that uses several formulas to extract the month and year from the start date. I created a pivot table with the data set but the date columns are being shown out of order. I have tried formatting the column as dates but the result is the same.

aeg4_caps_payroll_report_2022-01-01_thru_2023-08-01 NY.xlsx
	E	F	G	H
1	Start Date	Shift	Month	Month/Year
2	2/14/2022	0	0	Feb-2022
3	2/14/2022	1	0	Feb-2022
4	2/23/2022	1	0	Feb-2022
5	2/24/2022	0	0	Feb-2022
6	2/24/2022	1	0	Feb-2022
7	2/25/2022	1	1	Feb-2022
8	3/4/2022	1		Mar-2022
9	3/12/2023	1	1	Mar-2023
10	4/1/2023	1	0	Apr-2023
11	4/7/2023	1	0	Apr-2023
12	4/8/2023	1	0	Apr-2023
13	4/18/2023	1	1	Apr-2023
14	5/16/2023	1	0	May-2023
Bowery NY

Cell Formulas
Range	Formula
F2:F14	F2	=IF(E2<>E3,1,0)
G2:G14	G2	=IF(AND(B2=B3, YEAR(E2)=YEAR(E3)),MONTH(E3)-MONTH(E2),"")
H2:H14	H2	=CONCATENATE(TEXT(E2, "MMM"), "-",YEAR(E2))

aeg4_caps_payroll_report_2022-01-01_thru_2023-08-01 NY.xlsx
	B	C	D	E	F	G	H	I	J	K	L
3	Column Labels
4	Apr-2022	Apr-2023	Aug-2022	Aug-2023	Dec-2022	Feb-2022	Feb-2023	Jan-2022	Jan-2023	Jul-2022	Jul-2023
Sheet1

Thank you for your help.

 

[awoohaw]

My thought is that you are now trying to sort a text string as a value.

Instead of concatenating MMM-YYYY into text, just format the cells in Column H as "MMM-YYYY".
If you are concerned with multiple days in there, make the formula in column H this: Date(Year(E2),Month(E2),1)

 

[errollflynn]

My thought is that you are now trying to sort a text string as a value.

Instead of concatenating MMM-YYYY into text, just format the cells in Column H as "MMM-YYYY".
If you are concerned with multiple days in there, make the formula in column H this: Date(Year(E2),Month(E2),1)

Thank you!

 

[awoohaw]

My pleasure. I am happy you found a solution here.

Best Wishes!