Can't order by date months

%3CLINGO-SUB%20id%3D%22lingo-sub-2281483%22%20slang%3D%22en-US%22%3ECan't%20order%20by%20date%20months%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2281483%22%20slang%3D%22en-US%22%3E%3CPRE%3E%3CSPAN%20class%3D%22Y2IQFc%22%3EIn%20the%20%22repuestos%22%20tab%20at%20the%20end%20of%20the%20page%2C%20the%20pivot%20table%20I%20cannot%20sort%20the%20pivot%20table%20by%20dates.%0AI%20have%20windows%20365%20installed%20and%20the%20data%20as%20%22date%22%20but%20it%20still%20does%20not%20allow%20me%20to%20group%20by%20months.%20What%20is%20the%20problem%3F%20what%20can%20I%20do%20or%20try%3F%20Thanks%20in%20advance.%20Gaby%3C%2FSPAN%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2281483%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor
In the "repuestos" tab at the end of the page, the pivot table I cannot sort the pivot table by dates.
I have windows 365 installed and the data as "date" but it still does not allow me to group by months. What is the problem? what can I do or try? Thanks in advance. Gaby
1 Reply

@gabybornand The dates in the table were in fact texts. Simply setting the format as "Date" is not sufficient when the underlying data is a text. Dates in Excel are stored as numbers. You can check it by entering a formula somewhere like =ISNUMBER(B10). If the result is FALSE, you know for sure that it's not a number and Excel will not recognise it as a date.

 

Have fixed the dates with "Text-to-columns" (on the Data ribbon) and re-built the pivot table in the attached file. I trust that this is what you had in mind.