A field guide to Google Sheets
Step-by-step tutorials for every Google Sheets formula worth learning — from VLOOKUP and QUERY to ARRAYFORMULA, REGEXMATCH, and the rest of the Workspace toolkit. Written for people who live in the browser, not in Excel.
512 functions · 188 how-to tutorials · 16 categories
If you have ever tried to work with dates and timestamps without timezone surprises in Google Sheets and ended up wrestling with awkward workarounds, the DATE function is the cleaner solution you…
Continue reading →If you have ever tried to work with dates and timestamps without timezone surprises in Google Sheets and ended up wrestling with awkward workarounds, the DATEDIF function is the cleaner solution you…
Continue reading →If you have ever tried to work with dates and timestamps without timezone surprises in Google Sheets and ended up wrestling with awkward workarounds, the DATEVALUE function is the cleaner solution you…
Continue reading →If you have ever tried to work with dates and timestamps without timezone surprises in Google Sheets and ended up wrestling with awkward workarounds, the DAY function is the cleaner solution you…
Continue reading →If you have ever tried to work with dates and timestamps without timezone surprises in Google Sheets and ended up wrestling with awkward workarounds, the DAYS function is the cleaner solution you…
Continue reading →If you have ever tried to work with dates and timestamps without timezone surprises in Google Sheets and ended up wrestling with awkward workarounds, the DAYS360 function is the cleaner solution you…
Continue reading →If you have ever tried to work with dates and timestamps without timezone surprises in Google Sheets and ended up wrestling with awkward workarounds, the EDATE function is the cleaner solution you…
Continue reading →If you have ever tried to work with dates and timestamps without timezone surprises in Google Sheets and ended up wrestling with awkward workarounds, the EOMONTH function is the cleaner solution you…
Continue reading →If you have ever tried to work with dates and timestamps without timezone surprises in Google Sheets and ended up wrestling with awkward workarounds, the HOUR function is the cleaner solution you…
Continue reading →