Count weekdays between two dates
FormulasEasyDeterministic scoringLatest run
Passed by all 12 products on their best model.
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| 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.5J2=NETWORKDAYS(D2,E2)
| 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 | 6 | ||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 9 | ||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 7 | ||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 10 |
Pass criteria
All must be met, checked automatically.J2:J5hold the expected values, from formulas
Passed 22
Autosheet in Excel Opus 5.5 · Medium
J2=NETWORKDAYS(D2,E2)
| 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 | 6 | ||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 9 | ||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 7 | ||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 10 |
Autosheet in Excel GPT-6 Astra · Low
J2=NETWORKDAYS(D2,E2)
| 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 | 6 | ||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 9 | ||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 7 | ||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 10 |
Autosheet in Sheets Opus 5.5 · Medium
J2=NETWORKDAYS(D2, E2)
| 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 | 6 | ||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 9 | ||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 7 | ||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 10 |
Autosheet in Excel Sonnet 5.5 · Medium
J2=NETWORKDAYS(D2,E2)
| 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 | 6 | ||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 9 | ||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 7 | ||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 10 |
Claude in Excel Opus 5.5 · High
J2=NETWORKDAYS(DATEVALUE(D2),DATEVALUE(E2))
| 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 | 6 | ||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 9 | ||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 7 | ||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 10 |
Autosheet in Excel Haiku 5.5 · High
J2=NETWORKDAYS(D2,E2)
| 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 | 6 | ||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 9 | ||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 7 | ||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 10 |
Claude in Sheets Opus 5.5 · Medium
J2=NETWORKDAYS(DATEVALUE(D2),DATEVALUE(E2))
| 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 | 6 | ||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 9 | ||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 7 | ||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 10 |
Claude Code + Sheets MCP Opus 5.5 · Medium
J2=NETWORKDAYS(--D2,--E2)
| 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 | 6 | ||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 9 | ||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 7 | ||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 10 |
Autosheet in Excel GPT-6.1 Sol · Medium
J2=NETWORKDAYS(D2,E2)
| 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 | 6 | ||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 9 | ||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 7 | ||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 10 |
Claude Code + Autosheet MCP Opus 5.5 · Medium
J2=NETWORKDAYS(D2, E2)
| 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 | 6 | ||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 9 | ||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 7 | ||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 10 |
ChatGPT + Autosheet MCP GPT-6 · Medium
J2=NETWORKDAYS(D2, E2)
| 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 | 6 | ||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 9 | ||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 7 | ||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 10 |
Autosheet in Sheets Haiku 5.5 · High
J2=NETWORKDAYS(D2, E2)
| 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 | 6 | ||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 9 | ||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 7 | ||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 10 |
ChatGPT in Excel GPT-6 Astra · Medium
J2=NETWORKDAYS(D2,E2)
| 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 | 6 | ||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 9 | ||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 7 | ||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 10 |
Claude in Excel Haiku 5.5 · High
J2=NETWORKDAYS(DATEVALUE(D2),DATEVALUE(E2))
| 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 | 6 | ||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 9 | ||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 7 | ||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 10 |
Claude in Sheets Haiku 5.5 · High
J2=NETWORKDAYS(DATEVALUE(D2),DATEVALUE(E2))
| 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 | 6 | ||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 9 | ||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 7 | ||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 10 |
Autosheet in Excel GPT-6 Luna · High
J2=NETWORKDAYS(D2,E2)
| 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 | 6 | ||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 9 | ||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 7 | ||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 10 |
Copilot in Excel Auto
J2=NETWORKDAYS(D2,E2)
| 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 | 6 | ||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 9 | ||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 7 | ||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 10 |
ChatGPT + Drive MCP GPT-6 · Medium
J2=NETWORKDAYS(DATEVALUE(D2),DATEVALUE(E2))
| 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 | 6 | ||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 9 | ||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 7 | ||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 10 |
ChatGPT in Excel GPT-6 Luna · High
J2=NETWORKDAYS(D2,E2)
| 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 | 6 | ||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 9 | ||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 7 | ||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 10 |
Gemini in Sheets Auto
J2=NETWORKDAYS(D2, E2)
| 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 | 6 | ||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 9 | ||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 7 | ||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 10 |
ChatGPT in Sheets GPT-6 Astra · Medium
J2=NETWORKDAYS(D2,E2)
| 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 | 6 | ||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 9 | ||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 7 | ||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 10 |
ChatGPT in Sheets GPT-6 Luna · High
J2=NETWORKDAYS(D2,E2)
| 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 | 6 | ||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 9 | ||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 7 | ||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 10 |