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
-
Formula Parse Error in Google Sheets: 9 Causes and a Free Checker
“Formula parse error” means Google Sheets could not read your formula as valid syntax, so it never calculated it. The cell shows #ERROR!, and pointing at it shows the message…
-
NETWORKDAYS with Holidays in Google Sheets: Exclude Holidays from Working Days
To count working days between two dates in Google Sheets and skip holidays, list the holiday dates in a range and pass it as the third argument of NETWORKDAYS: =NETWORKDAYS(A2,…
-
Days Between Dates in Google Sheets: Inclusive vs Exclusive Counting
Subtracting two dates in Google Sheets gives an exclusive count: =B2-A2 returns 4 for Monday to Friday of the same week. If you want to count every day including both…
-
How to Calculate Days Between Dates in Google Sheets (5 Methods)
To count the days between two dates in Google Sheets, subtract the earlier date from the later one: =B2-A2. That works because Sheets stores every date as a number. The…
-
DATEDIF in Google Sheets: All 6 Units Explained (Y, M, D, MD, YM, YD)
DATEDIF calculates the difference between two dates in whole years, whole months or days. Its syntax is =DATEDIF(start_date, end_date, unit), where unit is one of six text codes: “Y”, “M”,…
-
How to Count Specific Weekdays Between Two Dates in Google Sheets
To count how many times a specific day of the week falls between two dates in Google Sheets, use NETWORKDAYS.INTL with a seven-character mask that leaves only that day as…
-
How to Calculate Age from Date of Birth in Google Sheets
To calculate someone’s age in Google Sheets, put the date of birth in A2 and use: =DATEDIF(A2, TODAY(), “Y”) This returns the number of complete years, so the age only…
-
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,…