Return ISO week numbers
FormulasEasyDeterministic scoringLatest run
Passed by all 12 products on their best model.
Prompt
Use formulas in H2:H5 to return the ISO week number for each due 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.5H2=ISOWEEKNUM(B2)
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 27 | |||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 29 | |||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 31 | |||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 34 |
Pass criteria
All must be met, checked automatically.H2:H5hold the expected values, from formulas
Passed 22
Autosheet in Excel Opus 5.5 · Medium
H2=ISOWEEKNUM(B2)
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 27 | |||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 29 | |||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 31 | |||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 34 |
Autosheet in Excel GPT-6 Astra · Low
H2=ISOWEEKNUM(B2)
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 27 | |||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 29 | |||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 31 | |||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 34 |
Autosheet in Sheets Opus 5.5 · Medium
H2=ISOWEEKNUM(B2)
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 27 | |||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 29 | |||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 31 | |||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 34 |
Autosheet in Excel Sonnet 5.5 · Medium
H2=ISOWEEKNUM(B2)
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 27 | |||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 29 | |||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 31 | |||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 34 |
Claude in Excel Opus 5.5 · High
H2=ISOWEEKNUM(DATE(LEFT(B2,4),MID(B2,6,2),RIGHT(B2,2)))
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 27 | |||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 29 | |||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 31 | |||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 34 |
Autosheet in Excel Haiku 5.5 · High
H2=ISOWEEKNUM(B2)
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 27 | |||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 29 | |||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 31 | |||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 34 |
Claude in Sheets Opus 5.5 · Medium
H2=ISOWEEKNUM(DATEVALUE(B2))
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 27 | |||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 29 | |||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 31 | |||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 34 |
Claude Code + Sheets MCP Opus 5.5 · Medium
H2=IF(B2="","",ISOWEEKNUM(DATEVALUE(B2)))
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 27 | |||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 29 | |||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 31 | |||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 34 |
Autosheet in Excel GPT-6.1 Sol · Medium
H2=ISOWEEKNUM(B2)
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 27 | |||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 29 | |||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 31 | |||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 34 |
Claude Code + Autosheet MCP Opus 5.5 · Medium
H2=ISOWEEKNUM(B2)
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 27 | |||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 29 | |||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 31 | |||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 34 |
ChatGPT + Autosheet MCP GPT-6 · Medium
H2=ISOWEEKNUM(B2)
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 27 | |||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 29 | |||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 31 | |||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 34 |
Autosheet in Sheets Haiku 5.5 · High
H2=ISOWEEKNUM(B2)
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 27 | |||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 29 | |||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 31 | |||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 34 |
ChatGPT in Excel GPT-6 Astra · Medium
H2=ISOWEEKNUM(IF(ISNUMBER(B2),B2,DATE(LEFT(B2,4),MID(B2,6,2),RIGHT(B2,2))))
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 27 | |||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 29 | |||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 31 | |||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 34 |
Claude in Excel Haiku 5.5 · High
H2=ISOWEEKNUM(DATE(LEFT(B2,4),MID(B2,6,2),RIGHT(B2,2)))
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 27 | |||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 29 | |||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 31 | |||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 34 |
Claude in Sheets Haiku 5.5 · High
H2=ISOWEEKNUM(DATE(LEFT(B2,4),MID(B2,6,2),RIGHT(B2,2)))
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 27 | |||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 29 | |||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 31 | |||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 34 |
Autosheet in Excel GPT-6 Luna · High
H2=ISOWEEKNUM(B2)
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 27 | |||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 29 | |||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 31 | |||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 34 |
Copilot in Excel Auto
H2=ISOWEEKNUM(B2)
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 27 | |||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 29 | |||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 31 | |||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 34 |
ChatGPT + Drive MCP GPT-6 · Medium
H2=ISOWEEKNUM(DATEVALUE(B2))
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 27 | |||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 29 | |||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 31 | |||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 34 |
ChatGPT in Excel GPT-6 Luna · High
H2=ISOWEEKNUM(B2)
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 27 | |||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 29 | |||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 31 | |||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 34 |
Gemini in Sheets Auto
H2=ISOWEEKNUM(B2)
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 27 | |||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 29 | |||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 31 | |||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 34 |
ChatGPT in Sheets GPT-6 Astra · Medium
H2=ISOWEEKNUM(B2)
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 27 | |||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 29 | |||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 31 | |||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 34 |
ChatGPT in Sheets GPT-6 Luna · High
H2=ISOWEEKNUM(B2)
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 27 | |||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 29 | |||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 31 | |||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 34 |