SOLVED

Urgent help

%3CLINGO-SUB%20id%3D%22lingo-sub-2687709%22%20slang%3D%22en-US%22%3EUrgent%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2687709%22%20slang%3D%22en-US%22%3EI%20need%20to%20sort%20this%20date%20column%20in%20chronological%20order%20but%20sort%20function%20doesn't%20work%20for%20%22from%20to%22%20dates%20in%20a%20cell.%20Is%20there%20any%20way%20I%20could%20sort%20this%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2687709%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2687782%22%20slang%3D%22en-US%22%3ERe%3A%20Urgent%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2687782%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F439137%22%20target%3D%22_blank%22%3E%40Srisamsakthi%3C%2FA%3E%26nbsp%3BI%20would%20split%20the%20column%20in%20two.%20One%20for%20the%20From%20date%2C%20one%20for%20the%20To%20date.%20Use%20%22Text%20To%20Columns%22%20for%20this%20and%20make%20sure%20that%20the%20two%20date%20columns%20are%20transformed%20to%20real%20dates%20(step%203%20of%203%2C%20select%20Date%20and%20DMY).%20Then%20custom%20sort.%20First%20sort%20on%20From%20date%2C%20ascending.%20Then%20on%20To%20date%2C%20ascending.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2688143%22%20slang%3D%22en-US%22%3ERe%3A%20Urgent%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2688143%22%20slang%3D%22en-US%22%3ETHANK%20YOU%20VERY%20MUCH!!%20It%20worked%3C%2FLINGO-BODY%3E
New Contributor
I need to sort this date column in chronological order but sort function doesn't work for "from to" dates in a cell. Is there any way I could sort this
2 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@Srisamsakthi I would split the column in two. One for the From date, one for the To date. Use "Text To Columns" for this and make sure that the two date columns are transformed to real dates (step 3 of 3, select Date and DMY). Then custom sort. First sort on From date, ascending. Then on To date, ascending.

THANK YOU VERY MUCH!! It worked