For the date sort function to work, Google Sheets needs to recognize your values. If you have invalid dates (in an unsupported format), those cells are read as plain text, giving incorrect results.

After years of waiting, Google Sheets finally supports the powerful XLOOKUP function, and has added other powerful new functions too.

You can use SUMIF in Google Sheets to add numbers together that are associated with a date range, specific text, or meet a numeric criterion.

Use either keyboard shortcuts or the NOW and TODAY functions to display the current date and time in Excel and Google Sheets spreadsheets together.

If you want to calculate the age from the date of birth in Google Sheets, then you can do so using DATEDIF or the Array formula. Learn how!

With new support for named functions, LAMBDA and helper functions, spreadsheet calculations — especially with arrays — may be more efficient and elegant.