You're a reporting analyst preparing a row-grouping column for a slide deck. The downstream chart axes display "Jan 2026", "Feb 2026", etc. — three-letter month abbreviation, single space, four-digit year. You have 12 raw dates in column A.
Your task:
- In column B (Month-Year), write a formula that returns the
"Mmm YYYY" string for each date.
- The formula must drag-fill from B2 → B13.
The TEXT format string "mmm yyyy" produces exactly this shape:
=TEXT(A2, "mmm yyyy")
Three ms give the 3-letter month abbreviation ("Jan", "Feb", …, "Dec"); four ys give the 4-digit year. The literal space between the two format groups passes through unchanged.
Graded cells: B2 (2026-01-15 → Jan 2026), B7 (2026-06-15 → Jun 2026), B13 (2026-12-25 → Dec 2026).
Open this problem on a desktop to attempt it.