All AutosheetBench tasks

Count weekdays between two dates

FormulasEasyDeterministic scoringLatest run

Passed by all 12 products on their best model.

Prompt and starting spreadsheet

Task files

Prompt

Use formulas in J2:J5 to count weekdays from each order date through its delivery date, including both endpoints and excluding weekends.

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

J2=NETWORKDAYS(D2,E2)

ABCDEFGHIJ
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-022026-06-012026-06-086
3B2026-07-152026-06-102026-06-032026-06-159
4C2026-08-022026-06-182026-06-172026-06-257
5D2026-08-202026-07-012026-07-1410

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

Passed 22

Autosheet in Excel Opus 5.5 · Medium

Passed12s · 3¢
Dates4 cells changed

J2=NETWORKDAYS(D2,E2)

ABCDEFGHIJ
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-022026-06-012026-06-086
3B2026-07-152026-06-102026-06-032026-06-159
4C2026-08-022026-06-182026-06-172026-06-257
5D2026-08-202026-07-012026-07-1410

Autosheet in Excel GPT-6 Astra · Low

Passed6s · 5¢
Dates4 cells changed

J2=NETWORKDAYS(D2,E2)

ABCDEFGHIJ
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-022026-06-012026-06-086
3B2026-07-152026-06-102026-06-032026-06-159
4C2026-08-022026-06-182026-06-172026-06-257
5D2026-08-202026-07-012026-07-1410

Autosheet in Sheets Opus 5.5 · Medium

Passed11s · 3¢
Dates4 cells changed

J2=NETWORKDAYS(D2, E2)

ABCDEFGHIJ
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-022026-06-012026-06-086
3B2026-07-152026-06-102026-06-032026-06-159
4C2026-08-022026-06-182026-06-172026-06-257
5D2026-08-202026-07-012026-07-1410

Autosheet in Excel Sonnet 5.5 · Medium

Passed4s · 1¢
Dates4 cells changed

J2=NETWORKDAYS(D2,E2)

ABCDEFGHIJ
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-022026-06-012026-06-086
3B2026-07-152026-06-102026-06-032026-06-159
4C2026-08-022026-06-182026-06-172026-06-257
5D2026-08-202026-07-012026-07-1410

Claude in Excel Opus 5.5 · High

Passed17s · 11¢
Dates4 cells changed

J2=NETWORKDAYS(DATEVALUE(D2),DATEVALUE(E2))

ABCDEFGHIJ
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-022026-06-012026-06-086
3B2026-07-152026-06-102026-06-032026-06-159
4C2026-08-022026-06-182026-06-172026-06-257
5D2026-08-202026-07-012026-07-1410

Autosheet in Excel Haiku 5.5 · High

Passed7s · 0.1¢
Dates4 cells changed

J2=NETWORKDAYS(D2,E2)

ABCDEFGHIJ
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-022026-06-012026-06-086
3B2026-07-152026-06-102026-06-032026-06-159
4C2026-08-022026-06-182026-06-172026-06-257
5D2026-08-202026-07-012026-07-1410

Claude in Sheets Opus 5.5 · Medium

Passed30s · 7¢
Dates4 cells changed

J2=NETWORKDAYS(DATEVALUE(D2),DATEVALUE(E2))

ABCDEFGHIJ
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-022026-06-012026-06-086
3B2026-07-152026-06-102026-06-032026-06-159
4C2026-08-022026-06-182026-06-172026-06-257
5D2026-08-202026-07-012026-07-1410

Claude Code + Sheets MCP Opus 5.5 · Medium

Passed26s · N/A
Dates4 cells changed

J2=NETWORKDAYS(--D2,--E2)

ABCDEFGHIJ
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-022026-06-012026-06-086
3B2026-07-152026-06-102026-06-032026-06-159
4C2026-08-022026-06-182026-06-172026-06-257
5D2026-08-202026-07-012026-07-1410

Autosheet in Excel GPT-6.1 Sol · Medium

Passed9s · 2¢
Dates4 cells changed

J2=NETWORKDAYS(D2,E2)

ABCDEFGHIJ
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-022026-06-012026-06-086
3B2026-07-152026-06-102026-06-032026-06-159
4C2026-08-022026-06-182026-06-172026-06-257
5D2026-08-202026-07-012026-07-1410

Claude Code + Autosheet MCP Opus 5.5 · Medium

Passed32s · N/A
Dates4 cells changed

J2=NETWORKDAYS(D2, E2)

ABCDEFGHIJ
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-022026-06-012026-06-086
3B2026-07-152026-06-102026-06-032026-06-159
4C2026-08-022026-06-182026-06-172026-06-257
5D2026-08-202026-07-012026-07-1410

ChatGPT + Autosheet MCP GPT-6 · Medium

Passed33s · N/A
Dates4 cells changed

J2=NETWORKDAYS(D2, E2)

ABCDEFGHIJ
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-022026-06-012026-06-086
3B2026-07-152026-06-102026-06-032026-06-159
4C2026-08-022026-06-182026-06-172026-06-257
5D2026-08-202026-07-012026-07-1410

Autosheet in Sheets Haiku 5.5 · High

Passed14s · 0.1¢
Dates4 cells changed

J2=NETWORKDAYS(D2, E2)

ABCDEFGHIJ
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-022026-06-012026-06-086
3B2026-07-152026-06-102026-06-032026-06-159
4C2026-08-022026-06-182026-06-172026-06-257
5D2026-08-202026-07-012026-07-1410

ChatGPT in Excel GPT-6 Astra · Medium

Passed19s · 39¢
Dates4 cells changed

J2=NETWORKDAYS(D2,E2)

ABCDEFGHIJ
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-022026-06-012026-06-086
3B2026-07-152026-06-102026-06-032026-06-159
4C2026-08-022026-06-182026-06-172026-06-257
5D2026-08-202026-07-012026-07-1410

Claude in Excel Haiku 5.5 · High

Passed12s · 0.4¢
Dates4 cells changed

J2=NETWORKDAYS(DATEVALUE(D2),DATEVALUE(E2))

ABCDEFGHIJ
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-022026-06-012026-06-086
3B2026-07-152026-06-102026-06-032026-06-159
4C2026-08-022026-06-182026-06-172026-06-257
5D2026-08-202026-07-012026-07-1410

Claude in Sheets Haiku 5.5 · High

Passed24s · 0.5¢
Dates4 cells changed

J2=NETWORKDAYS(DATEVALUE(D2),DATEVALUE(E2))

ABCDEFGHIJ
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-022026-06-012026-06-086
3B2026-07-152026-06-102026-06-032026-06-159
4C2026-08-022026-06-182026-06-172026-06-257
5D2026-08-202026-07-012026-07-1410

Autosheet in Excel GPT-6 Luna · High

Passed6s · 0.1¢
Dates4 cells changed

J2=NETWORKDAYS(D2,E2)

ABCDEFGHIJ
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-022026-06-012026-06-086
3B2026-07-152026-06-102026-06-032026-06-159
4C2026-08-022026-06-182026-06-172026-06-257
5D2026-08-202026-07-012026-07-1410

Copilot in Excel Auto

Passed21s · N/A
Dates4 cells changed

J2=NETWORKDAYS(D2,E2)

ABCDEFGHIJ
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-022026-06-012026-06-086
3B2026-07-152026-06-102026-06-032026-06-159
4C2026-08-022026-06-182026-06-172026-06-257
5D2026-08-202026-07-012026-07-1410

ChatGPT + Drive MCP GPT-6 · Medium

Passed29s · N/A
Dates4 cells changed

J2=NETWORKDAYS(DATEVALUE(D2),DATEVALUE(E2))

ABCDEFGHIJ
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-022026-06-012026-06-086
3B2026-07-152026-06-102026-06-032026-06-159
4C2026-08-022026-06-182026-06-172026-06-257
5D2026-08-202026-07-012026-07-1410

ChatGPT in Excel GPT-6 Luna · High

Passed14s · 0.4¢
Dates4 cells changed

J2=NETWORKDAYS(D2,E2)

ABCDEFGHIJ
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-022026-06-012026-06-086
3B2026-07-152026-06-102026-06-032026-06-159
4C2026-08-022026-06-182026-06-172026-06-257
5D2026-08-202026-07-012026-07-1410

Gemini in Sheets Auto

Passed40s · N/A
Dates4 cells changed

J2=NETWORKDAYS(D2, E2)

ABCDEFGHIJ
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-022026-06-012026-06-086
3B2026-07-152026-06-102026-06-032026-06-159
4C2026-08-022026-06-182026-06-172026-06-257
5D2026-08-202026-07-012026-07-1410

ChatGPT in Sheets GPT-6 Astra · Medium

Passed19s · 31¢
Dates4 cells changed

J2=NETWORKDAYS(D2,E2)

ABCDEFGHIJ
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-022026-06-012026-06-086
3B2026-07-152026-06-102026-06-032026-06-159
4C2026-08-022026-06-182026-06-172026-06-257
5D2026-08-202026-07-012026-07-1410

ChatGPT in Sheets GPT-6 Luna · High

Passed22s · 0.3¢
Dates4 cells changed

J2=NETWORKDAYS(D2,E2)

ABCDEFGHIJ
1ItemDue DateInquiry DateOrder DateDelivery DateYearMonthWeekElapsed DaysBusiness Days
2A2026-07-012026-06-022026-06-012026-06-086
3B2026-07-152026-06-102026-06-032026-06-159
4C2026-08-022026-06-182026-06-172026-06-257
5D2026-08-202026-07-012026-07-1410