Much more realistically, you wouldn’t choose to sort just one column. You'd probably be aiming to sort multiple columns of data by date. Suppose there is a dataset as shown underneath wherever you'll want to sort it depending on the day in Column A. Right before sharing, review the macro https://www.customguide.com/google-sheets/conditional-formatting-google-sheets