You're an operations analyst loading 12 rows of order dates into the warehouse system. The export from upstream has two date formats coexisting in one column:
- ISO:
2026-01-15
- US slash:
02/20/2026
The warehouse system requires a single canonical format: YYYY-MM-DD as a string.
Your task:
- In column B (Canonical Date), write a formula that produces the canonical
YYYY-MM-DD string for each input regardless of source format.
- The formula must drag-fill from B2 → B13.
The two-step pattern is DATEVALUE (parses both formats into an Excel date serial) followed by TEXT (formats the serial as a string): =TEXT(DATEVALUE(A2), "yyyy-mm-dd").
Graded cells: B3 (02/20/2026 → 2026-02-20), B6 (05/22/2026 → 2026-05-22), B11 (10/05/2026 → 2026-10-05).
Open this problem on a desktop to attempt it.