All AutosheetBench tasks

Return ISO week numbers

FormulasEasyDeterministic scoringLatest run

Passed by all 12 products on their best model.

Prompt and starting spreadsheet

Task files

Prompt

Use formulas in H2:H5 to return the ISO week number for 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
Dates4 cells changed

H2=ISOWEEKNUM(B2)

ABCDEFGHI
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed Days
2A2026-07-012026-06-022026-06-012026-06-0827
3B2026-07-152026-06-102026-06-032026-06-1529
4C2026-08-022026-06-182026-06-172026-06-2531
5D2026-08-202026-07-012026-07-1434

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.
  • H2:H5 hold the expected values, from formulas

Passed 22

Autosheet in Excel Opus 5.5 · Medium

Passed10s · 3¢
Dates4 cells changed

H2=ISOWEEKNUM(B2)

ABCDEFGHI
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed Days
2A2026-07-012026-06-022026-06-012026-06-0827
3B2026-07-152026-06-102026-06-032026-06-1529
4C2026-08-022026-06-182026-06-172026-06-2531
5D2026-08-202026-07-012026-07-1434

Autosheet in Excel GPT-6 Astra · Low

Passed7s · 5¢
Dates4 cells changed

H2=ISOWEEKNUM(B2)

ABCDEFGHI
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed Days
2A2026-07-012026-06-022026-06-012026-06-0827
3B2026-07-152026-06-102026-06-032026-06-1529
4C2026-08-022026-06-182026-06-172026-06-2531
5D2026-08-202026-07-012026-07-1434

Autosheet in Sheets Opus 5.5 · Medium

Passed13s · 2¢
Dates4 cells changed

H2=ISOWEEKNUM(B2)

ABCDEFGHI
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed Days
2A2026-07-012026-06-022026-06-012026-06-0827
3B2026-07-152026-06-102026-06-032026-06-1529
4C2026-08-022026-06-182026-06-172026-06-2531
5D2026-08-202026-07-012026-07-1434

Autosheet in Excel Sonnet 5.5 · Medium

Passed4s · 0.9¢
Dates4 cells changed

H2=ISOWEEKNUM(B2)

ABCDEFGHI
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed Days
2A2026-07-012026-06-022026-06-012026-06-0827
3B2026-07-152026-06-102026-06-032026-06-1529
4C2026-08-022026-06-182026-06-172026-06-2531
5D2026-08-202026-07-012026-07-1434

Claude in Excel Opus 5.5 · High

Passed15s · 11¢
Dates4 cells changed

H2=ISOWEEKNUM(DATE(LEFT(B2,4),MID(B2,6,2),RIGHT(B2,2)))

ABCDEFGHI
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed Days
2A2026-07-012026-06-022026-06-012026-06-0827
3B2026-07-152026-06-102026-06-032026-06-1529
4C2026-08-022026-06-182026-06-172026-06-2531
5D2026-08-202026-07-012026-07-1434

Autosheet in Excel Haiku 5.5 · High

Passed7s · 0.1¢
Dates4 cells changed

H2=ISOWEEKNUM(B2)

ABCDEFGHI
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed Days
2A2026-07-012026-06-022026-06-012026-06-0827
3B2026-07-152026-06-102026-06-032026-06-1529
4C2026-08-022026-06-182026-06-172026-06-2531
5D2026-08-202026-07-012026-07-1434

Claude in Sheets Opus 5.5 · Medium

Passed22s · 8¢
Dates4 cells changed

H2=ISOWEEKNUM(DATEVALUE(B2))

ABCDEFGHI
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed Days
2A2026-07-012026-06-022026-06-012026-06-0827
3B2026-07-152026-06-102026-06-032026-06-1529
4C2026-08-022026-06-182026-06-172026-06-2531
5D2026-08-202026-07-012026-07-1434

Claude Code + Sheets MCP Opus 5.5 · Medium

Passed32s · N/A
Dates4 cells changed

H2=IF(B2="","",ISOWEEKNUM(DATEVALUE(B2)))

ABCDEFGHI
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed Days
2A2026-07-012026-06-022026-06-012026-06-0827
3B2026-07-152026-06-102026-06-032026-06-1529
4C2026-08-022026-06-182026-06-172026-06-2531
5D2026-08-202026-07-012026-07-1434

Autosheet in Excel GPT-6.1 Sol · Medium

Passed10s · 2¢
Dates4 cells changed

H2=ISOWEEKNUM(B2)

ABCDEFGHI
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed Days
2A2026-07-012026-06-022026-06-012026-06-0827
3B2026-07-152026-06-102026-06-032026-06-1529
4C2026-08-022026-06-182026-06-172026-06-2531
5D2026-08-202026-07-012026-07-1434

Claude Code + Autosheet MCP Opus 5.5 · Medium

Passed36s · N/A
Dates4 cells changed

H2=ISOWEEKNUM(B2)

ABCDEFGHI
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed Days
2A2026-07-012026-06-022026-06-012026-06-0827
3B2026-07-152026-06-102026-06-032026-06-1529
4C2026-08-022026-06-182026-06-172026-06-2531
5D2026-08-202026-07-012026-07-1434

ChatGPT + Autosheet MCP GPT-6 · Medium

Passed22s · N/A
Dates4 cells changed

H2=ISOWEEKNUM(B2)

ABCDEFGHI
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed Days
2A2026-07-012026-06-022026-06-012026-06-0827
3B2026-07-152026-06-102026-06-032026-06-1529
4C2026-08-022026-06-182026-06-172026-06-2531
5D2026-08-202026-07-012026-07-1434

Autosheet in Sheets Haiku 5.5 · High

Passed16s · 0.3¢
Dates4 cells changed

H2=ISOWEEKNUM(B2)

ABCDEFGHI
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed Days
2A2026-07-012026-06-022026-06-012026-06-0827
3B2026-07-152026-06-102026-06-032026-06-1529
4C2026-08-022026-06-182026-06-172026-06-2531
5D2026-08-202026-07-012026-07-1434

ChatGPT in Excel GPT-6 Astra · Medium

Passed19s · 40¢
Dates4 cells changed

H2=ISOWEEKNUM(IF(ISNUMBER(B2),B2,DATE(LEFT(B2,4),MID(B2,6,2),RIGHT(B2,2))))

ABCDEFGHI
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed Days
2A2026-07-012026-06-022026-06-012026-06-0827
3B2026-07-152026-06-102026-06-032026-06-1529
4C2026-08-022026-06-182026-06-172026-06-2531
5D2026-08-202026-07-012026-07-1434

Claude in Excel Haiku 5.5 · High

Passed11s · 0.5¢
Dates4 cells changed

H2=ISOWEEKNUM(DATE(LEFT(B2,4),MID(B2,6,2),RIGHT(B2,2)))

ABCDEFGHI
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed Days
2A2026-07-012026-06-022026-06-012026-06-0827
3B2026-07-152026-06-102026-06-032026-06-1529
4C2026-08-022026-06-182026-06-172026-06-2531
5D2026-08-202026-07-012026-07-1434

Claude in Sheets Haiku 5.5 · High

Passed26s · 0.6¢
Dates4 cells changed

H2=ISOWEEKNUM(DATE(LEFT(B2,4),MID(B2,6,2),RIGHT(B2,2)))

ABCDEFGHI
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed Days
2A2026-07-012026-06-022026-06-012026-06-0827
3B2026-07-152026-06-102026-06-032026-06-1529
4C2026-08-022026-06-182026-06-172026-06-2531
5D2026-08-202026-07-012026-07-1434

Autosheet in Excel GPT-6 Luna · High

Passed6s · 0.1¢
Dates4 cells changed

H2=ISOWEEKNUM(B2)

ABCDEFGHI
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed Days
2A2026-07-012026-06-022026-06-012026-06-0827
3B2026-07-152026-06-102026-06-032026-06-1529
4C2026-08-022026-06-182026-06-172026-06-2531
5D2026-08-202026-07-012026-07-1434

Copilot in Excel Auto

Passed15s · N/A
Dates4 cells changed

H2=ISOWEEKNUM(B2)

ABCDEFGHI
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed Days
2A2026-07-012026-06-022026-06-012026-06-0827
3B2026-07-152026-06-102026-06-032026-06-1529
4C2026-08-022026-06-182026-06-172026-06-2531
5D2026-08-202026-07-012026-07-1434

ChatGPT + Drive MCP GPT-6 · Medium

Passed21s · N/A
Dates4 cells changed

H2=ISOWEEKNUM(DATEVALUE(B2))

ABCDEFGHI
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed Days
2A2026-07-012026-06-022026-06-012026-06-0827
3B2026-07-152026-06-102026-06-032026-06-1529
4C2026-08-022026-06-182026-06-172026-06-2531
5D2026-08-202026-07-012026-07-1434

ChatGPT in Excel GPT-6 Luna · High

Passed15s · 0.4¢
Dates4 cells changed

H2=ISOWEEKNUM(B2)

ABCDEFGHI
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed Days
2A2026-07-012026-06-022026-06-012026-06-0827
3B2026-07-152026-06-102026-06-032026-06-1529
4C2026-08-022026-06-182026-06-172026-06-2531
5D2026-08-202026-07-012026-07-1434

Gemini in Sheets Auto

Passed46s · N/A
Dates4 cells changed

H2=ISOWEEKNUM(B2)

ABCDEFGHI
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed Days
2A2026-07-012026-06-022026-06-012026-06-0827
3B2026-07-152026-06-102026-06-032026-06-1529
4C2026-08-022026-06-182026-06-172026-06-2531
5D2026-08-202026-07-012026-07-1434

ChatGPT in Sheets GPT-6 Astra · Medium

Passed17s · 31¢
Dates4 cells changed

H2=ISOWEEKNUM(B2)

ABCDEFGHI
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed Days
2A2026-07-012026-06-022026-06-012026-06-0827
3B2026-07-152026-06-102026-06-032026-06-1529
4C2026-08-022026-06-182026-06-172026-06-2531
5D2026-08-202026-07-012026-07-1434

ChatGPT in Sheets GPT-6 Luna · High

Passed24s · 0.3¢
Dates4 cells changed

H2=ISOWEEKNUM(B2)

ABCDEFGHI
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed Days
2A2026-07-012026-06-022026-06-012026-06-0827
3B2026-07-152026-06-102026-06-032026-06-1529
4C2026-08-022026-06-182026-06-172026-06-2531
5D2026-08-202026-07-012026-07-1434