Extract the year and month from dates
FormulasEasyDeterministic scoringLatest run
Passed by all 12 products on their best model.
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| 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.5F2=YEAR(B2)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 2026 | 7 | |
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 2026 | 7 | |
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 2026 | 8 | |
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 2026 | 8 |
Excel and Sheets · All types · All models · All outputs
Pass criteria
All must be met, checked automatically.F2:G5hold the expected values, from formulas
Passed 22
Autosheet in Excel Opus 5.5 · Medium
Passed11s · 3¢
F2=YEAR(B2)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 2026 | 7 | |
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 2026 | 7 | |
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 2026 | 8 | |
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 2026 | 8 |
Autosheet in Excel GPT-6 Astra · Low
Passed9s · 7¢
F2=YEAR(B2)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 2026 | 7 | |
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 2026 | 7 | |
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 2026 | 8 | |
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 2026 | 8 |
Autosheet in Sheets Opus 5.5 · Medium
Passed15s · 3¢
F2=YEAR(B2)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 2026 | 7 | |
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 2026 | 7 | |
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 2026 | 8 | |
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 2026 | 8 |
Autosheet in Excel Sonnet 5.5 · Medium
Passed4s · 1¢
F2=YEAR(B2)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 2026 | 7 | |
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 2026 | 7 | |
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 2026 | 8 | |
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 2026 | 8 |
Claude in Excel Opus 5.5 · High
Passed15s · 10¢
F2=YEAR(B2)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 2026 | 7 | |
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 2026 | 7 | |
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 2026 | 8 | |
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 2026 | 8 |
Autosheet in Excel Haiku 5.5 · High
Passed6s · 0.1¢
F2=YEAR(B2)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 2026 | 7 | |
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 2026 | 7 | |
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 2026 | 8 | |
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 2026 | 8 |
Claude in Sheets Opus 5.5 · Medium
Passed34s · 7¢
F2=YEAR(B2)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 2026 | 7 | |
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 2026 | 7 | |
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 2026 | 8 | |
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 2026 | 8 |
Claude Code + Sheets MCP Opus 5.5 · Medium
Passed26s · N/A
F2=YEAR(B2)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 2026 | 7 | |
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 2026 | 7 | |
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 2026 | 8 | |
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 2026 | 8 |
Autosheet in Excel GPT-6.1 Sol · Medium
Passed17s · 2¢
F2=YEAR(B2)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 2026 | 7 | |
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 2026 | 7 | |
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 2026 | 8 | |
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 2026 | 8 |
Claude Code + Autosheet MCP Opus 5.5 · Medium
Passed29s · N/A
F2=YEAR(IF(ISNUMBER(B2), B2, DATEVALUE(B2)))
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 2026 | 7 | |
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 2026 | 7 | |
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 2026 | 8 | |
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 2026 | 8 |
ChatGPT + Autosheet MCP GPT-6 · Medium
Passed30s · N/A
F2=YEAR(B2)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 2026 | 7 | |
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 2026 | 7 | |
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 2026 | 8 | |
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 2026 | 8 |
Autosheet in Sheets Haiku 5.5 · High
Passed14s · 0.3¢
F2=YEAR(B2)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 2026 | 7 | |
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 2026 | 7 | |
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 2026 | 8 | |
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 2026 | 8 |
ChatGPT in Excel GPT-6 Astra · Medium
Passed14s · 40¢
F2=YEAR(B2)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 2026 | 7 | |
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 2026 | 7 | |
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 2026 | 8 | |
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 2026 | 8 |
Claude in Excel Haiku 5.5 · High
Passed12s · 0.5¢
F2=YEAR(DATEVALUE(B2))
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 2026 | 7 | |
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 2026 | 7 | |
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 2026 | 8 | |
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 2026 | 8 |
Claude in Sheets Haiku 5.5 · High
Passed29s · 0.6¢
F2=VALUE(LEFT(B2,4))
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 2026 | 7 | |
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 2026 | 7 | |
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 2026 | 8 | |
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 2026 | 8 |
Autosheet in Excel GPT-6 Luna · High
Passed9s · 0.1¢
F2=YEAR(B2)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 2026 | 7 | |
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 2026 | 7 | |
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 2026 | 8 | |
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 2026 | 8 |
Copilot in Excel Auto
Passed19s · N/A
F2=YEAR(B2)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 2026 | 7 | |
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 2026 | 7 | |
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 2026 | 8 | |
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 2026 | 8 |
ChatGPT + Drive MCP GPT-6 · Medium
Passed25s · N/A
F2=YEAR(DATEVALUE(B2))
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 2026 | 7 | |
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 2026 | 7 | |
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 2026 | 8 | |
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 2026 | 8 |
ChatGPT in Excel GPT-6 Luna · High
Passed15s · 0.4¢
F2=YEAR(B2)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 2026 | 7 | |
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 2026 | 7 | |
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 2026 | 8 | |
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 2026 | 8 |
Gemini in Sheets Auto
Passed54s · N/A
F2=YEAR(B2)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 2026 | 7 | |
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 2026 | 7 | |
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 2026 | 8 | |
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 2026 | 8 |
ChatGPT in Sheets GPT-6 Astra · Medium
Passed25s · 32¢
F2=YEAR(B2)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 2026 | 7 | |
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 2026 | 7 | |
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 2026 | 8 | |
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 2026 | 8 |
ChatGPT in Sheets GPT-6 Luna · High
Passed20s · 0.3¢
F2=YEAR(B2)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 2026 | 7 | |
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 2026 | 7 | |
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 2026 | 8 | |
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 2026 | 8 |