ISDATE

This IS one of Google's own published results: the page carries a real Formula/Result table in the article body (not an embedded live sheet), and this row is quoted from it verbatim. The page's Examples table has four rows and this file asserts all four. Note that they are NOT the same strings as the page's separate 'Sample formulas' line (ISDATE("7/20/1969"), ISDATE("July 20"), ISDATE(A1)), which prints no results at all -- the two sets must not be conflated. Google's ISDATE page, read live on 2026-08-31 at https://support.google.com/docs/answer/9061381. BATCH PROVENANCE (batch H, the first Sheets/LibreOffice-only batch). Every function in this batch has x == false in docs/data/compat.json: it is a Google Sheets function that Microsoft does not document at all, so this corpus makes NO claim about it in that engine and nothing here is measured against that vendor's documentation. The authority is Google's own support.google.com function page, cited by full URL and by the date it was read -- Google publishes no version number for these pages, so a bare URL dates nothing. WHAT GOOGLE ACTUALLY PRINTS, WHICH IS LESS THAN IT LOOKS: most of these pages carry a 'Sample Usage' block of FORMULAS WITH NO RESULTS. Where a value below is Google's own published output the note says so; where it is derived from the page's stated semantics the note says that instead, and says from which sentence. No value in this batch was taken from a search snippet, a blog or a mirror. LIBREOFFICE: probed on all four pinned builds (24.2.0.3, 24.8.7.2, 25.2.0.3, 25.8.7.3) in five storage spellings -- plain, _xlfn., COM.MICROSOFT., ORG.OPENOFFICE. and _xlfn.ORG.OPENOFFICE. -- and #NAME? under every one of them, so the expected values below describe Google Sheets and the LibreOffice column records absence.

This IS one of Google's own published results: the page carries a real Formula/Result table in the article body (not an embedded live sheet), and this row is quoted from it verbatim. THIS IS THE ROW WORTH WATCHING, AND IT IS GOOGLE'S OWN. Read as ISO year-month-day, "1969-20-07" has month 20 and cannot be a date; the page nonetheless prints TRUE, which is only consistent with a year-day-month reading. The page says nothing about locale anywhere, and the corpus asserts the published value rather than the value the reading suggests. If the executed engine returns FALSE, that divergence is the finding and the page is what will be wrong. Google's ISDATE page, read live on 2026-08-31 at https://support.google.com/docs/answer/9061381.

This IS one of Google's own published results: the page carries a real Formula/Result table in the article body (not an embedded live sheet), and this row is quoted from it verbatim. Google's ISDATE page, read live on 2026-08-31 at https://support.google.com/docs/answer/9061381.

This IS one of Google's own published results: the page carries a real Formula/Result table in the article body (not an embedded live sheet), and this row is quoted from it verbatim. The pair with row 3 shows the page treating an INCOMPLETE date and an IMPOSSIBLE date the same way. The page's only Note is unrelated to either: "Ensure your date has quotation marks around it, unless it's a reference to a cell." Google's ISDATE page, read live on 2026-08-31 at https://support.google.com/docs/answer/9061381.

This IS one of Google's own published results: the page carries a real Formula/Result table in the article body (not an embedded live sheet), and this row is quoted from it verbatim. The page's Examples table has four rows and this file asserts all four. Note that they are NOT the same strings as the page's separate 'Sample formulas' line (ISDATE("7/20/1969"), ISDATE("July 20"), ISDATE(A1)), which prints no results at all -- the two sets must not be conflated. Google's ISDATE page, read live on 2026-08-31 at https://support.google.com/docs/answer/9061381. BATCH PROVENANCE (batch H, the first Sheets/LibreOffice-only batch). Every function in this batch has x == false in docs/data/compat.json: it is a Google Sheets function that Microsoft does not document at all, so this corpus makes NO claim about it in that engine and nothing here is measured against that vendor's documentation. The authority is Google's own support.google.com function page, cited by full URL and by the date it was read -- Google publishes no version number for these pages, so a bare URL dates nothing. WHAT GOOGLE ACTUALLY PRINTS, WHICH IS LESS THAN IT LOOKS: most of these pages carry a 'Sample Usage' block of FORMULAS WITH NO RESULTS. Where a value below is Google's own published output the note says so; where it is derived from the page's stated semantics the note says that instead, and says from which sentence. No value in this batch was taken from a search snippet, a blog or a mirror. LIBREOFFICE: probed on all four pinned builds (24.2.0.3, 24.8.7.2, 25.2.0.3, 25.8.7.3) in five storage spellings -- plain, _xlfn., COM.MICROSOFT., ORG.OPENOFFICE. and _xlfn.ORG.OPENOFFICE. -- and #NAME? under every one of them, so the expected values below describe Google Sheets and the LibreOffice column records absence.

This IS one of Google's own published results: the page carries a real Formula/Result table in the article body (not an embedded live sheet), and this row is quoted from it verbatim. THIS IS THE ROW WORTH WATCHING, AND IT IS GOOGLE'S OWN. Read as ISO year-month-day, "1969-20-07" has month 20 and cannot be a date; the page nonetheless prints TRUE, which is only consistent with a year-day-month reading. The page says nothing about locale anywhere, and the corpus asserts the published value rather than the value the reading suggests. If the executed engine returns FALSE, that divergence is the finding and the page is what will be wrong. Google's ISDATE page, read live on 2026-08-31 at https://support.google.com/docs/answer/9061381.

This IS one of Google's own published results: the page carries a real Formula/Result table in the article body (not an embedded live sheet), and this row is quoted from it verbatim. Google's ISDATE page, read live on 2026-08-31 at https://support.google.com/docs/answer/9061381.

This IS one of Google's own published results: the page carries a real Formula/Result table in the article body (not an embedded live sheet), and this row is quoted from it verbatim. The pair with row 3 shows the page treating an INCOMPLETE date and an IMPOSSIBLE date the same way. The page's only Note is unrelated to either: "Ensure your date has quotation marks around it, unless it's a reference to a cell." Google's ISDATE page, read live on 2026-08-31 at https://support.google.com/docs/answer/9061381.

This IS one of Google's own published results: the page carries a real Formula/Result table in the article body (not an embedded live sheet), and this row is quoted from it verbatim. The page's Examples table has four rows and this file asserts all four. Note that they are NOT the same strings as the page's separate 'Sample formulas' line (ISDATE("7/20/1969"), ISDATE("July 20"), ISDATE(A1)), which prints no results at all -- the two sets must not be conflated. Google's ISDATE page, read live on 2026-08-31 at https://support.google.com/docs/answer/9061381. BATCH PROVENANCE (batch H, the first Sheets/LibreOffice-only batch). Every function in this batch has x == false in docs/data/compat.json: it is a Google Sheets function that Microsoft does not document at all, so this corpus makes NO claim about it in that engine and nothing here is measured against that vendor's documentation. The authority is Google's own support.google.com function page, cited by full URL and by the date it was read -- Google publishes no version number for these pages, so a bare URL dates nothing. WHAT GOOGLE ACTUALLY PRINTS, WHICH IS LESS THAN IT LOOKS: most of these pages carry a 'Sample Usage' block of FORMULAS WITH NO RESULTS. Where a value below is Google's own published output the note says so; where it is derived from the page's stated semantics the note says that instead, and says from which sentence. No value in this batch was taken from a search snippet, a blog or a mirror. LIBREOFFICE: probed on all four pinned builds (24.2.0.3, 24.8.7.2, 25.2.0.3, 25.8.7.3) in five storage spellings -- plain, _xlfn., COM.MICROSOFT., ORG.OPENOFFICE. and _xlfn.ORG.OPENOFFICE. -- and #NAME? under every one of them, so the expected values below describe Google Sheets and the LibreOffice column records absence.

This IS one of Google's own published results: the page carries a real Formula/Result table in the article body (not an embedded live sheet), and this row is quoted from it verbatim. THIS IS THE ROW WORTH WATCHING, AND IT IS GOOGLE'S OWN. Read as ISO year-month-day, "1969-20-07" has month 20 and cannot be a date; the page nonetheless prints TRUE, which is only consistent with a year-day-month reading. The page says nothing about locale anywhere, and the corpus asserts the published value rather than the value the reading suggests. If the executed engine returns FALSE, that divergence is the finding and the page is what will be wrong. Google's ISDATE page, read live on 2026-08-31 at https://support.google.com/docs/answer/9061381.

This IS one of Google's own published results: the page carries a real Formula/Result table in the article body (not an embedded live sheet), and this row is quoted from it verbatim. Google's ISDATE page, read live on 2026-08-31 at https://support.google.com/docs/answer/9061381.

This IS one of Google's own published results: the page carries a real Formula/Result table in the article body (not an embedded live sheet), and this row is quoted from it verbatim. The pair with row 3 shows the page treating an INCOMPLETE date and an IMPOSSIBLE date the same way. The page's only Note is unrelated to either: "Ensure your date has quotation marks around it, unless it's a reference to a cell." Google's ISDATE page, read live on 2026-08-31 at https://support.google.com/docs/answer/9061381.