How to sort multiple columns independently by date order that have text in the same row in Excel?

What youre trying to do, sorting each column independently while keeping the text paired with its date — isn't possible with standard sort features since Excel sorts entire rows together by default. But I'm pretty sure you can work around this by splitting each column into its own mini-table. Just separate the columns into different ranges (side by side if needed), and sort each one individually using the "Sort A to Z" option within that column's range.

If you want something more automated you could use formulas to extract and sort dates dynamically with the SORTBY or FILTER functions (if you're using Excel 365 or Excel 2021+ features), but for a static sort in Excel Professional Plus 2024, separating the columns and sorting them one at a time is your best bet.