All AutosheetBench tasks

Extract the year and month from dates

FormulasEasyDeterministic scoringLatest run

Passed by all 12 products on their best model.

Prompt and starting spreadsheet

Task files

Prompt

Use formulas to fill F2:F5 with the numeric year and G2:G5 with the numeric month from each due 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
Dates8 cells changed

F2=YEAR(B2)

ABCDEFGH
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeek
2A2026-07-012026-06-022026-06-012026-06-0820267
3B2026-07-152026-06-102026-06-032026-06-1520267
4C2026-08-022026-06-182026-06-172026-06-2520268
5D2026-08-202026-07-012026-07-1420268

How each AI configuration did

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

Pass criteria

All must be met, checked automatically.
  • F2:G5 hold the expected values, from formulas

Passed 22

Autosheet in Excel Opus 5.5 · Medium

Passed11s · 3¢
Dates8 cells changed

F2=YEAR(B2)

ABCDEFGH
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeek
2A2026-07-012026-06-022026-06-012026-06-0820267
3B2026-07-152026-06-102026-06-032026-06-1520267
4C2026-08-022026-06-182026-06-172026-06-2520268
5D2026-08-202026-07-012026-07-1420268

Autosheet in Excel GPT-6 Astra · Low

Passed9s · 7¢
Dates8 cells changed

F2=YEAR(B2)

ABCDEFGH
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeek
2A2026-07-012026-06-022026-06-012026-06-0820267
3B2026-07-152026-06-102026-06-032026-06-1520267
4C2026-08-022026-06-182026-06-172026-06-2520268
5D2026-08-202026-07-012026-07-1420268

Autosheet in Sheets Opus 5.5 · Medium

Passed15s · 3¢
Dates8 cells changed

F2=YEAR(B2)

ABCDEFGH
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeek
2A2026-07-012026-06-022026-06-012026-06-0820267
3B2026-07-152026-06-102026-06-032026-06-1520267
4C2026-08-022026-06-182026-06-172026-06-2520268
5D2026-08-202026-07-012026-07-1420268

Autosheet in Excel Sonnet 5.5 · Medium

Passed4s · 1¢
Dates8 cells changed

F2=YEAR(B2)

ABCDEFGH
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeek
2A2026-07-012026-06-022026-06-012026-06-0820267
3B2026-07-152026-06-102026-06-032026-06-1520267
4C2026-08-022026-06-182026-06-172026-06-2520268
5D2026-08-202026-07-012026-07-1420268

Claude in Excel Opus 5.5 · High

Passed15s · 10¢
Dates8 cells changed

F2=YEAR(B2)

ABCDEFGH
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeek
2A2026-07-012026-06-022026-06-012026-06-0820267
3B2026-07-152026-06-102026-06-032026-06-1520267
4C2026-08-022026-06-182026-06-172026-06-2520268
5D2026-08-202026-07-012026-07-1420268

Autosheet in Excel Haiku 5.5 · High

Passed6s · 0.1¢
Dates8 cells changed

F2=YEAR(B2)

ABCDEFGH
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeek
2A2026-07-012026-06-022026-06-012026-06-0820267
3B2026-07-152026-06-102026-06-032026-06-1520267
4C2026-08-022026-06-182026-06-172026-06-2520268
5D2026-08-202026-07-012026-07-1420268

Claude in Sheets Opus 5.5 · Medium

Passed34s · 7¢
Dates8 cells changed

F2=YEAR(B2)

ABCDEFGH
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeek
2A2026-07-012026-06-022026-06-012026-06-0820267
3B2026-07-152026-06-102026-06-032026-06-1520267
4C2026-08-022026-06-182026-06-172026-06-2520268
5D2026-08-202026-07-012026-07-1420268

Claude Code + Sheets MCP Opus 5.5 · Medium

Passed26s · N/A
Dates8 cells changed

F2=YEAR(B2)

ABCDEFGH
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeek
2A2026-07-012026-06-022026-06-012026-06-0820267
3B2026-07-152026-06-102026-06-032026-06-1520267
4C2026-08-022026-06-182026-06-172026-06-2520268
5D2026-08-202026-07-012026-07-1420268

Autosheet in Excel GPT-6.1 Sol · Medium

Passed17s · 2¢
Dates8 cells changed

F2=YEAR(B2)

ABCDEFGH
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeek
2A2026-07-012026-06-022026-06-012026-06-0820267
3B2026-07-152026-06-102026-06-032026-06-1520267
4C2026-08-022026-06-182026-06-172026-06-2520268
5D2026-08-202026-07-012026-07-1420268

Claude Code + Autosheet MCP Opus 5.5 · Medium

Passed29s · N/A
Dates8 cells changed

F2=YEAR(IF(ISNUMBER(B2), B2, DATEVALUE(B2)))

ABCDEFGH
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeek
2A2026-07-012026-06-022026-06-012026-06-0820267
3B2026-07-152026-06-102026-06-032026-06-1520267
4C2026-08-022026-06-182026-06-172026-06-2520268
5D2026-08-202026-07-012026-07-1420268

ChatGPT + Autosheet MCP GPT-6 · Medium

Passed30s · N/A
Dates8 cells changed

F2=YEAR(B2)

ABCDEFGH
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeek
2A2026-07-012026-06-022026-06-012026-06-0820267
3B2026-07-152026-06-102026-06-032026-06-1520267
4C2026-08-022026-06-182026-06-172026-06-2520268
5D2026-08-202026-07-012026-07-1420268

Autosheet in Sheets Haiku 5.5 · High

Passed14s · 0.3¢
Dates8 cells changed

F2=YEAR(B2)

ABCDEFGH
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeek
2A2026-07-012026-06-022026-06-012026-06-0820267
3B2026-07-152026-06-102026-06-032026-06-1520267
4C2026-08-022026-06-182026-06-172026-06-2520268
5D2026-08-202026-07-012026-07-1420268

ChatGPT in Excel GPT-6 Astra · Medium

Passed14s · 40¢
Dates8 cells changed

F2=YEAR(B2)

ABCDEFGH
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeek
2A2026-07-012026-06-022026-06-012026-06-0820267
3B2026-07-152026-06-102026-06-032026-06-1520267
4C2026-08-022026-06-182026-06-172026-06-2520268
5D2026-08-202026-07-012026-07-1420268

Claude in Excel Haiku 5.5 · High

Passed12s · 0.5¢
Dates8 cells changed

F2=YEAR(DATEVALUE(B2))

ABCDEFGH
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeek
2A2026-07-012026-06-022026-06-012026-06-0820267
3B2026-07-152026-06-102026-06-032026-06-1520267
4C2026-08-022026-06-182026-06-172026-06-2520268
5D2026-08-202026-07-012026-07-1420268

Claude in Sheets Haiku 5.5 · High

Passed29s · 0.6¢
Dates8 cells changed

F2=VALUE(LEFT(B2,4))

ABCDEFGH
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeek
2A2026-07-012026-06-022026-06-012026-06-0820267
3B2026-07-152026-06-102026-06-032026-06-1520267
4C2026-08-022026-06-182026-06-172026-06-2520268
5D2026-08-202026-07-012026-07-1420268

Autosheet in Excel GPT-6 Luna · High

Passed9s · 0.1¢
Dates8 cells changed

F2=YEAR(B2)

ABCDEFGH
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeek
2A2026-07-012026-06-022026-06-012026-06-0820267
3B2026-07-152026-06-102026-06-032026-06-1520267
4C2026-08-022026-06-182026-06-172026-06-2520268
5D2026-08-202026-07-012026-07-1420268

Copilot in Excel Auto

Passed19s · N/A
Dates8 cells changed

F2=YEAR(B2)

ABCDEFGH
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeek
2A2026-07-012026-06-022026-06-012026-06-0820267
3B2026-07-152026-06-102026-06-032026-06-1520267
4C2026-08-022026-06-182026-06-172026-06-2520268
5D2026-08-202026-07-012026-07-1420268

ChatGPT + Drive MCP GPT-6 · Medium

Passed25s · N/A
Dates8 cells changed

F2=YEAR(DATEVALUE(B2))

ABCDEFGH
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeek
2A2026-07-012026-06-022026-06-012026-06-0820267
3B2026-07-152026-06-102026-06-032026-06-1520267
4C2026-08-022026-06-182026-06-172026-06-2520268
5D2026-08-202026-07-012026-07-1420268

ChatGPT in Excel GPT-6 Luna · High

Passed15s · 0.4¢
Dates8 cells changed

F2=YEAR(B2)

ABCDEFGH
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeek
2A2026-07-012026-06-022026-06-012026-06-0820267
3B2026-07-152026-06-102026-06-032026-06-1520267
4C2026-08-022026-06-182026-06-172026-06-2520268
5D2026-08-202026-07-012026-07-1420268

Gemini in Sheets Auto

Passed54s · N/A
Dates8 cells changed

F2=YEAR(B2)

ABCDEFGH
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeek
2A2026-07-012026-06-022026-06-012026-06-0820267
3B2026-07-152026-06-102026-06-032026-06-1520267
4C2026-08-022026-06-182026-06-172026-06-2520268
5D2026-08-202026-07-012026-07-1420268

ChatGPT in Sheets GPT-6 Astra · Medium

Passed25s · 32¢
Dates8 cells changed

F2=YEAR(B2)

ABCDEFGH
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeek
2A2026-07-012026-06-022026-06-012026-06-0820267
3B2026-07-152026-06-102026-06-032026-06-1520267
4C2026-08-022026-06-182026-06-172026-06-2520268
5D2026-08-202026-07-012026-07-1420268

ChatGPT in Sheets GPT-6 Luna · High

Passed20s · 0.3¢
Dates8 cells changed

F2=YEAR(B2)

ABCDEFGH
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeek
2A2026-07-012026-06-022026-06-012026-06-0820267
3B2026-07-152026-06-102026-06-032026-06-1520267
4C2026-08-022026-06-182026-06-172026-06-2520268
5D2026-08-202026-07-012026-07-1420268