How We Create and Test Our Content

Spreadsheet advice is only useful if it works when you paste it into your own sheet. This page explains how GridDial articles and tools are made, what we check before publishing and how we fix mistakes.

Why we write each article

We write about problems people actually run into in Google Sheets: formulas that return the wrong number, error messages that are hard to decode and tasks that take too many manual steps. Each article answers one question. If two topics would end up saying the same thing, we combine them into one page instead of publishing near-duplicates.

How articles are produced

  1. Research. We start from Google’s official function documentation and note any documented limits or exceptions.
  2. Drafting with AI assistance. Articles are drafted with the help of an AI assistant (Claude, by Anthropic). AI output is treated as a first draft, never as a source of truth: nothing it writes is published until it has passed the next two steps.
  3. Worked examples. Every example uses its own sample data, and the expected result is calculated independently of the formula being explained, with a separate script that computes the dates without using Google Sheets.
  4. Testing in Google Sheets. Every formula is entered in a real Google Sheets spreadsheet and its result is compared with the expected result. We also test the edge cases an article mentions: empty cells, text instead of dates, dates in the wrong order and spreadsheets set to different locales.
  5. Publishing. Each article says when its formulas were tested. If a formula cannot be confirmed, it is not presented as working.

What testing has changed

Testing is not a formality. Our first rounds of tests changed several drafts before they were published:

  • A draft said that a misspelled DATEDIF unit returns #VALUE!. Google Sheets returned #NUM!, so the article now says so.
  • A draft said that a holiday stored as text is skipped by NETWORKDAYS. In Google Sheets it makes the whole formula return #VALUE!.
  • Google’s own help page says DATEVALUE returns an error when given a number. In our tests it returned the date’s serial number instead, so we describe what Google Sheets actually does.

When Google’s documentation and Google Sheets disagree, we report the behavior we observed and the date we observed it.

Regional settings

Google Sheets uses different date formats and argument separators depending on the spreadsheet’s locale. In the United States a formula looks like =DATEDIF(A2, B2, "D"), while in many European locales it uses semicolons: =DATEDIF(A2; B2; "D"). Our examples use the United States format unless an article says otherwise.

Our tools

GridDial tools run entirely in your browser. What you type is not sent to our server or stored. Each tool shows the formula you would use in Google Sheets to get the same result, so you can check it yourself.

Updates and corrections

Google Sheets changes over time. We review articles when functions change and update the tested date when we retest. If you find an error, please report it on the contact page. We correct confirmed mistakes as soon as possible.

Independence

GridDial is not affiliated with Google or Microsoft. Advertising on the site does not influence our recommendations, and we do not accept payment to feature products.