Google Sheets formulas that work the first time
Step-by-step tutorials, fixes for formula errors and free tools. Every formula is tested in Google Sheets before we publish it.
Latest guides
-
Sort by Date in Google Sheets When Dates Are dd/mm/yyyy (and Why They Sort Wrong)
If dates written as dd/mm/yyyy sort in the wrong order in Google Sheets, they are almost always stored as text, not as dates. Text is sorted character by character, so…
-
NETWORKDAYS Not Working in Google Sheets? 7 Causes and Fixes
When NETWORKDAYS gives an error or a number you don’t expect, the cause is almost always one of the seven below. Each one was reproduced in Google Sheets, with the…
-
How to Get the Day Name from a Date in Google Sheets
To get the day of the week from a date in Google Sheets, use TEXT with the format “dddd”. With a date in A2: =TEXT(A2, “dddd”) For Monday, November 9,…