Add 14 days to due dates
FormulasEasyDeterministic scoringLatest run
Passed by all 12 products on their best model.
Prompt
Use formulas in K2:K5 to add 14 days to 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.5K2=DATEVALUE(B2)+14
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days | Business Days | Due Date +14 |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 2026-07-15 | |||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 2026-07-29 | |||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 2026-08-16 | |||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 2026-09-03 |
Excel and Sheets · All types · All models · All outputs
Pass criteria
All must be met, checked automatically.K2:K5hold the expected values, from formulas
Passed 22
Autosheet in Excel Opus 5.5 · Medium
Passed15s · 14¢
K2=DATEVALUE(B2)+14
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days | Business Days | Due Date +14 |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 2026-07-15 | |||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 2026-07-29 | |||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 2026-08-16 | |||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 2026-09-03 |
Autosheet in Excel GPT-6 Astra · Low
Passed13s · 8¢
K2=B2+14
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | 2026-07-15 | |||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 2026-07-29 | |||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 2026-08-16 | |||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 2026-09-03 |
Autosheet in Sheets Opus 5.5 · Medium
Passed15s · 11¢
K2=B2+14
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days | Business Days | Due Date + 14 |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 2026-07-15 | |||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 2026-07-29 | |||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 2026-08-16 | |||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 2026-09-03 |
Autosheet in Excel Sonnet 5.5 · Medium
Passed6s · 1¢
K2=B2+14
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days | Business Days | Due Date + 14 Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 2026-07-15 | |||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 2026-07-29 | |||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 2026-08-16 | |||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 2026-09-03 |
Claude in Excel Opus 5.5 · High
Passed17s · 15¢
K2=DATEVALUE(B2)+14
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days | Business Days | Due Date + 14 |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 2026-07-15 | |||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 2026-07-29 | |||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 2026-08-16 | |||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 2026-09-03 |
Autosheet in Excel Haiku 5.5 · High
Passed9s · 0.1¢
K2=B2+14
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days | Business Days | Due Date + 14 Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 2026-07-15 | |||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 2026-07-29 | |||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 2026-08-16 | |||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 2026-09-03 |
Claude in Sheets Opus 5.5 · Medium
Passed34s · 15¢
K2=DATEVALUE(B2)+14
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days | Business Days | Due Date + 14 |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 2026-07-15 | |||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 2026-07-29 | |||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 2026-08-16 | |||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 2026-09-03 |
Claude Code + Sheets MCP Opus 5.5 · Medium
Passed1m 6s · N/A
K2=IF(B2="","",DATEVALUE(B2)+14)
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | 2026-07-15 | |||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 2026-07-29 | |||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 2026-08-16 | |||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 2026-09-03 |
Autosheet in Excel GPT-6.1 Sol · Medium
Passed20s · 8¢
K2=B2+14
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days | Business Days | Due Date + 14 Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 2026-07-15 | |||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 2026-07-29 | |||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 2026-08-16 | |||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 2026-09-03 |
Claude Code + Autosheet MCP Opus 5.5 · Medium
Passed37s · N/A
K2=B2+14
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days | Business Days | Due Date + 14 Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 2026-07-15 | |||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 2026-07-29 | |||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 2026-08-16 | |||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 2026-09-03 |
ChatGPT + Autosheet MCP GPT-6 · Medium
Passed36s · N/A
K2=DATEVALUE(B2)+14
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | 2026-07-15 | |||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 2026-07-29 | |||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 2026-08-16 | |||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 2026-09-03 |
Autosheet in Sheets Haiku 5.5 · High
Passed29s · 0.4¢
K2=B2+14
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days | Business Days | Due Date + 14 Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 2026-07-15 | |||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 2026-07-29 | |||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 2026-08-16 | |||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 2026-09-03 |
ChatGPT in Excel GPT-6 Astra · Medium
Passed26s · 42¢
K2=B2+14
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | 2026-07-15 | |||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 2026-07-29 | |||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 2026-08-16 | |||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 2026-09-03 |
Claude in Excel Haiku 5.5 · High
Passed11s · 1¢
K2=DATE(VALUE(LEFT(B2,4)),VALUE(MID(B2,6,2)),VALUE(RIGHT(B2,2)))+14
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days | Business Days | Due Date + 14 Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 2026-07-15 | |||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 2026-07-29 | |||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 2026-08-16 | |||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 2026-09-03 |
Claude in Sheets Haiku 5.5 · High
Passed29s · 0.7¢
K2=DATEVALUE(B2)+14
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Due Date | Inquiry Date | Order Date | Delivery Date | Year | Month | Week | Elapsed Days | Business Days | Due Date + 14 Days |
| 2 | A | 2026-07-01 | 2026-06-02 | 2026-06-01 | 2026-06-08 | 2026-07-15 | |||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 2026-07-29 | |||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 2026-08-16 | |||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 2026-09-03 |
Autosheet in Excel GPT-6 Luna · High
Passed7s · 0.4¢
K2=B2+14
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | 46218 | |||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 46232 | |||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 46250 | |||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 46268 |
Copilot in Excel Auto
Passed19s · N/A
K2=B2+14
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | 2026-07-15 | |||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 2026-07-29 | |||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 2026-08-16 | |||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 2026-09-03 |
ChatGPT + Drive MCP GPT-6 · Medium
Passed33s · N/A
K2=DATEVALUE(B2)+14
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | 2026-07-15 | |||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 2026-07-29 | |||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 2026-08-16 | |||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 2026-09-03 |
ChatGPT in Excel GPT-6 Luna · High
Passed32s · 0.5¢
K2=DATEVALUE(B2)+14
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | 2026-07-15 | |||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 2026-07-29 | |||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 2026-08-16 | |||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 2026-09-03 |
Gemini in Sheets Auto
Passed53s · N/A
K2=B2+14
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | 2026-07-15 | |||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 2026-07-29 | |||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 2026-08-16 | |||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 2026-09-03 |
ChatGPT in Sheets GPT-6 Astra · Medium
Passed23s · 33¢
K2=IF(ISNUMBER(B2),B2,DATE(LEFT(B2,4),MID(B2,6,2),RIGHT(B2,2)))+14
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | 2026-07-15 | |||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 2026-07-29 | |||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 2026-08-16 | |||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 2026-09-03 |
ChatGPT in Sheets GPT-6 Luna · High
Passed22s · 0.3¢
K2=B2+14
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | 46218 | |||||
| 3 | B | 2026-07-15 | 2026-06-10 | 2026-06-03 | 2026-06-15 | 46232 | |||||
| 4 | C | 2026-08-02 | 2026-06-18 | 2026-06-17 | 2026-06-25 | 46250 | |||||
| 5 | D | 2026-08-20 | 2026-07-01 | 2026-07-14 | 46268 |