All AutosheetBench tasks

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 and starting spreadsheet

Task files

Prompt

How many days have passed since each inquiry date?

Starting spreadsheet

Dates
ABCDEFGHIJ
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-022026-06-012026-06-08
3B2026-07-152026-06-102026-06-032026-06-15
4C2026-08-022026-06-182026-06-172026-06-25
5D2026-08-202026-07-012026-07-14

A passing output

Autosheet in Excel · Opus 5.5
Dates4 cells changed

I2=IF(C2="","",TODAY()-C2)

ABCDEFGHIJ
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-022026-06-012026-06-08114
3B2026-07-152026-06-102026-06-032026-06-15106
4C2026-08-022026-06-182026-06-172026-06-2598
5D2026-08-202026-07-012026-07-14

How each AI configuration did

18 of 22 passRun files
Excel and Sheets · All types · All models · All outputs

Pass criteria

All must be met, checked automatically.
  • I5 is empty
  • I2:I5 use formulas that refer to column C of their row, with IF and TODAY, without ARRAYFORMULA or QUERY
  • Every cell in I2:I4 is filled

Passed 18

Autosheet in Excel Opus 5.5 · Medium

Passed13s · 4¢
Dates4 cells changed

I2=IF(C2="","",TODAY()-C2)

ABCDEFGHIJ
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-022026-06-012026-06-08114
3B2026-07-152026-06-102026-06-032026-06-15106
4C2026-08-022026-06-182026-06-172026-06-2598
5D2026-08-202026-07-012026-07-14

Autosheet in Excel GPT-6 Astra · Low

Passed10s · 7¢
Dates5 cells changed

I2=IF(C2="","",TODAY()-C2)

ABCDEFGHIJ
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-022026-06-012026-06-08102
3B2026-07-152026-06-102026-06-032026-06-1594
4C2026-08-022026-06-182026-06-172026-06-2586
5D2026-08-202026-07-012026-07-14
6

Autosheet in Sheets Opus 5.5 · Medium

Passed14s · 4¢
Dates4 cells changed

I2=IF(C2="", "", TODAY()-C2)

ABCDEFGHIJ
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-022026-06-012026-06-08134
3B2026-07-152026-06-102026-06-032026-06-15126
4C2026-08-022026-06-182026-06-172026-06-25118
5D2026-08-202026-07-012026-07-14

Autosheet in Excel Sonnet 5.5 · Medium

Passed9s · 2¢
Dates4 cells changed

I2=IF(C2="","",TODAY()-C2)

ABCDEFGHIJ
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-022026-06-012026-06-08130
3B2026-07-152026-06-102026-06-032026-06-15122
4C2026-08-022026-06-182026-06-172026-06-25114
5D2026-08-202026-07-012026-07-14

Claude in Excel Opus 5.5 · High

Passed19s · 11¢
Dates4 cells changed

I2=IF(C2="","",TODAY()-DATEVALUE(C2))

ABCDEFGHIJ
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-022026-06-012026-06-08163
3B2026-07-152026-06-102026-06-032026-06-15155
4C2026-08-022026-06-182026-06-172026-06-25147
5D2026-08-202026-07-012026-07-14

Autosheet in Excel Haiku 5.5 · High

Passed10s · 0.1¢
Dates4 cells changed

I2=IF(C2="","",TODAY()-C2)

ABCDEFGHIJ
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-022026-06-012026-06-08129
3B2026-07-152026-06-102026-06-032026-06-15121
4C2026-08-022026-06-182026-06-172026-06-25113
5D2026-08-202026-07-012026-07-14

Claude in Sheets Opus 5.5 · Medium

Passed28s · 7¢
Dates4 cells changed

I2=IF(C2="","",TODAY()-DATEVALUE(C2))

ABCDEFGHIJ
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-022026-06-012026-06-08164
3B2026-07-152026-06-102026-06-032026-06-15156
4C2026-08-022026-06-182026-06-172026-06-25148
5D2026-08-202026-07-012026-07-14

Claude Code + Sheets MCP Opus 5.5 · Medium

Passed43s · N/A
Dates4 cells changed

I2=IF(C2="","",DAYS(TODAY(),C2))

ABCDEFGHIJ
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-022026-06-012026-06-08125
3B2026-07-152026-06-102026-06-032026-06-15117
4C2026-08-022026-06-182026-06-172026-06-25109
5D2026-08-202026-07-012026-07-14

Autosheet in Excel GPT-6.1 Sol · Medium

Passed14s · 2¢
Dates5 cells changed

I2=IF(C2="","",TODAY()-C2)

ABCDEFGHIJ
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-022026-06-012026-06-08123
3B2026-07-152026-06-102026-06-032026-06-15115
4C2026-08-022026-06-182026-06-172026-06-25107
5D2026-08-202026-07-012026-07-14
6

Autosheet in Sheets Haiku 5.5 · High

Passed32s · 0.2¢
Dates4 cells changed

I2=IF(C2="","",TODAY()-C2)

ABCDEFGHIJ
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-022026-06-012026-06-08167
3B2026-07-152026-06-102026-06-032026-06-15159
4C2026-08-022026-06-182026-06-172026-06-25151
5D2026-08-202026-07-012026-07-14

ChatGPT in Excel GPT-6 Astra · Medium

Passed26s · 41¢
Dates4 cells changed

I2=IF(C2="","",TODAY()-IF(ISNUMBER(C2),INT(C2),DATE(LEFT(C2,4),MID(C2,6,2),RIGHT(C2,2))))

ABCDEFGHIJ
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-022026-06-012026-06-08164
3B2026-07-152026-06-102026-06-032026-06-15156
4C2026-08-022026-06-182026-06-172026-06-25148
5D2026-08-202026-07-012026-07-14

Claude in Sheets Haiku 5.5 · High

Passed38s · 1¢
Dates4 cells changed

I2=IF(C2="","",TODAY()-C2)

ABCDEFGHIJ
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-022026-06-012026-06-08167
3B2026-07-152026-06-102026-06-032026-06-15159
4C2026-08-022026-06-182026-06-172026-06-25151
5D2026-08-202026-07-012026-07-14

Autosheet in Excel GPT-6 Luna · High

Passed15s · 0.2¢
Dates4 cells changed

I2=IF(C2="","",TODAY()-C2)

ABCDEFGHIJ
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-022026-06-012026-06-08114
3B2026-07-152026-06-102026-06-032026-06-15106
4C2026-08-022026-06-182026-06-172026-06-2598
5D2026-08-202026-07-012026-07-14

Copilot in Excel Auto

Passed17s · N/A
Dates4 cells changed

I2=IF(C2="","",TODAY()-C2)

ABCDEFGHIJ
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-022026-06-012026-06-0888
3B2026-07-152026-06-102026-06-032026-06-1580
4C2026-08-022026-06-182026-06-172026-06-2572
5D2026-08-202026-07-012026-07-14

ChatGPT + Drive MCP GPT-6 · Medium

Passed48s · N/A
Dates4 cells changed

I2=IF(C2="","",TODAY()-DATEVALUE(C2))

ABCDEFGHIJ
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-022026-06-012026-06-08130
3B2026-07-152026-06-102026-06-032026-06-15122
4C2026-08-022026-06-182026-06-172026-06-25114
5D2026-08-202026-07-012026-07-14

ChatGPT in Excel GPT-6 Luna · High

Passed14s · 0.4¢
Dates4 cells changed

I2=IF(C2="","",TODAY()-C2)

ABCDEFGHIJ
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-022026-06-012026-06-08165
3B2026-07-152026-06-102026-06-032026-06-15157
4C2026-08-022026-06-182026-06-172026-06-25149
5D2026-08-202026-07-012026-07-14

ChatGPT in Sheets GPT-6 Astra · Medium

Passed20s · 33¢
Dates4 cells changed

I2=IF(C2="","",TODAY()-IF(ISNUMBER(C2),C2,DATE(LEFT(C2,4),MID(C2,6,2),RIGHT(C2,2))))

ABCDEFGHIJ
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-022026-06-012026-06-08164
3B2026-07-152026-06-102026-06-032026-06-15156
4C2026-08-022026-06-182026-06-172026-06-25148
5D2026-08-202026-07-012026-07-14

ChatGPT in Sheets GPT-6 Luna · High

Passed50s · 0.4¢
Dates4 cells changed

I2=IF(C2="","",TODAY()-C2)

ABCDEFGHIJ
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-022026-06-012026-06-08167
3B2026-07-152026-06-102026-06-032026-06-15159
4C2026-08-022026-06-182026-06-172026-06-25151
5D2026-08-202026-07-012026-07-14

Failed 4

Claude Code + Autosheet MCP Opus 5.5 · Medium

Failed34s · N/A
Dates5 cells changedWrong or missing value

K2=IF(C2="", "", TODAY()-C2)

ABCDEFGHIJK
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness DaysDays Since Inquiry
2A2026-07-012026-06-022026-06-012026-06-08125
3B2026-07-152026-06-102026-06-032026-06-15117
4C2026-08-022026-06-182026-06-172026-06-25109
5D2026-08-202026-07-012026-07-14

Why it failed: All cells were left empty.

ChatGPT + Autosheet MCP GPT-6 · Medium

Failed59s · N/A
Dates20 cells changedWrong or missing value

D2=IF(C2="", "", TODAY() - C2)

ABCDEFGHIJK
1ItemDue DateInquiry DateDays Since InquiryOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-021282026-06-012026-06-08
3B2026-07-152026-06-101202026-06-032026-06-15
4C2026-08-022026-06-181122026-06-172026-06-25
5D2026-08-202026-07-012026-07-14

Why it failed: All cells were left empty.

Claude in Excel Haiku 5.5 · High

Failed24s · 0.5¢
Dates6 cells changedWrong or missing value

I2=IF(C2="","",$L$2-DATEVALUE(C2))

ABCDEFGHIJKL
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness DaysAs-of date
2A2026-07-012026-06-022026-06-012026-06-081662026-11-15
3B2026-07-152026-06-102026-06-032026-06-15158
4C2026-08-022026-06-182026-06-172026-06-25150
5D2026-08-202026-07-012026-07-14

Why it failed: Formula function missing on I2.

Gemini in Sheets Auto

Failed19s · N/A
DatesNo cell changedWrong or missing value
ABCDEFGHIJ
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-022026-06-012026-06-08
3B2026-07-152026-06-102026-06-032026-06-15
4C2026-08-022026-06-182026-06-172026-06-25
5D2026-08-202026-07-012026-07-14

Why it failed: All cells were left empty.