Count the days since each inquiry
FormulasMediumDeterministic scoringLatest run
Passed by 9 of 12 products on their best model. Failed: Claude Code + Autosheet MCP, ChatGPT + Autosheet MCP and Gemini in Sheets.
Prompt
How many days have passed since each inquiry date?
Starting spreadsheet
Dates| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days | Business Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | |||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | |||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | |||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 |
A passing output
Autosheet in Excel · Opus 5.5I2=IF(C2="","",TODAY()-C2)
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days | Business Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 114 | ||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 106 | ||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 98 | ||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 |
Pass criteria
All must be met, checked automatically.I5is emptyI2:I5use formulas that refer to column C of their row, withIFandTODAY, withoutARRAYFORMULAorQUERY- Every cell in
I2:I4is filled
Passed 18
Autosheet in Excel Opus 5.5 · Medium
I2=IF(C2="","",TODAY()-C2)
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days | Business Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 114 | ||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 106 | ||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 98 | ||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 |
Autosheet in Excel GPT-6 Astra · Low
I2=IF(C2="","",TODAY()-C2)
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days | Business Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 102 | ||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 94 | ||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 86 | ||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | ||||||
| 6 |
Autosheet in Sheets Opus 5.5 · Medium
I2=IF(C2="", "", TODAY()-C2)
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days | Business Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 134 | ||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 126 | ||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 118 | ||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 |
Autosheet in Excel Sonnet 5.5 · Medium
I2=IF(C2="","",TODAY()-C2)
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days | Business Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 130 | ||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 122 | ||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 114 | ||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 |
Claude in Excel Opus 5.5 · High
I2=IF(C2="","",TODAY()-DATEVALUE(C2))
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days | Business Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 163 | ||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 155 | ||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 147 | ||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 |
Autosheet in Excel Haiku 5.5 · High
I2=IF(C2="","",TODAY()-C2)
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days | Business Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 129 | ||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 121 | ||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 113 | ||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 |
Claude in Sheets Opus 5.5 · Medium
I2=IF(C2="","",TODAY()-DATEVALUE(C2))
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days | Business Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 164 | ||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 156 | ||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 148 | ||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 |
Claude Code + Sheets MCP Opus 5.5 · Medium
I2=IF(C2="","",DAYS(TODAY(),C2))
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days | Business Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 125 | ||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 117 | ||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 109 | ||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 |
Autosheet in Excel GPT-6.1 Sol · Medium
I2=IF(C2="","",TODAY()-C2)
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days | Business Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 123 | ||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 115 | ||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 107 | ||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | ||||||
| 6 |
Autosheet in Sheets Haiku 5.5 · High
I2=IF(C2="","",TODAY()-C2)
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days | Business Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 167 | ||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 159 | ||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 151 | ||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 |
ChatGPT in Excel GPT-6 Astra · Medium
I2=IF(C2="","",TODAY()-IF(ISNUMBER(C2),INT(C2),DATE(LEFT(C2,4),MID(C2,6,2),RIGHT(C2,2))))
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days | Business Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 164 | ||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 156 | ||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 148 | ||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 |
Claude in Sheets Haiku 5.5 · High
I2=IF(C2="","",TODAY()-C2)
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days | Business Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 167 | ||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 159 | ||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 151 | ||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 |
Autosheet in Excel GPT-6 Luna · High
I2=IF(C2="","",TODAY()-C2)
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days | Business Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 114 | ||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 106 | ||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 98 | ||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 |
Copilot in Excel Auto
I2=IF(C2="","",TODAY()-C2)
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days | Business Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 88 | ||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 80 | ||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 72 | ||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 |
ChatGPT + Drive MCP GPT-6 · Medium
I2=IF(C2="","",TODAY()-DATEVALUE(C2))
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days | Business Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 130 | ||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 122 | ||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 114 | ||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 |
ChatGPT in Excel GPT-6 Luna · High
I2=IF(C2="","",TODAY()-C2)
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days | Business Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 165 | ||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 157 | ||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 149 | ||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 |
ChatGPT in Sheets GPT-6 Astra · Medium
I2=IF(C2="","",TODAY()-IF(ISNUMBER(C2),C2,DATE(LEFT(C2,4),MID(C2,6,2),RIGHT(C2,2))))
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days | Business Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 164 | ||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 156 | ||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 148 | ||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 |
ChatGPT in Sheets GPT-6 Luna · High
I2=IF(C2="","",TODAY()-C2)
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days | Business Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 167 | ||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 159 | ||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 151 | ||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 |
Failed 4
Claude Code + Autosheet MCP Opus 5.5 · Medium
K2=IF(C2="", "", TODAY()-C2)
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days | Business Days | Days Since Inquiry |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 125 | |||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 117 | |||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 109 | |||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 |
Why it failed: All cells were left empty.
ChatGPT + Autosheet MCP GPT-6 · Medium
D2=IF(C2="", "", TODAY() - C2)
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Days Since Inquiry | Order Date | Delivery Date | Year | Month | Week | Elapsed Days | Business Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 128 | 2026-06-01 | 2026-06-08 | |||||
| 3 | B | 2026-07-15 | 2026-06-10 | 120 | 2026-06-03 | 2026-06-15 | |||||
| 4 | C | 2026-08-02 | 2026-06-18 | 112 | 2026-06-17 | 2026-06-25 | |||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 |
Why it failed: All cells were left empty.
Claude in Excel Haiku 5.5 · High
I2=IF(C2="","",$L$2-DATEVALUE(C2))
| A | B | C | D | E | F | G | H | I | J | K | L | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days | Business Days | As-of date | |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 166 | 2026-11-15 | |||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 158 | ||||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 150 | ||||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 |
Why it failed: Formula function missing on I2.
Gemini in Sheets Auto
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days | Business Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | |||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | |||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | |||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 |
Why it failed: All cells were left empty.