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.

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

Learn how to use IF & nested IF statement in Google Sheets. & highlight a row using conditional formatting, set up multiple conditional formatting rules.

Google Sheets’ formula suggestions are like autofill for math It can suggest functions based on your data, and will auto-select your range ...