Reproduce the Tenure-Cohort Headcount Chart

You're an HR analyst preparing a board-deck slide that bands the headcount by tenure cohort: 0–1y, 1–3y, 3–5y, 5y+. The bar chart on the left shows what your VP needs the slide to look like — your job is to derive those four numbers from the employee table at A2:B13 so they can plug into the chart caption.

Use 2026-06-01 as the literal "as-of" date (=DATE(2026, 6, 1)) so the cohort math is deterministic. A "1–3y" employee is one whose hire date is ≥ 3 years before today and < 1 year before today — i.e., hired between 2023-06-01 (inclusive) and 2025-06-01 (exclusive). Other bands follow the same half-open-interval convention.

Column D has the four band labels (0-1y, 1-3y, 3-5y, 5y+) at D2:D5. Your job is to fill E2:E5 with the headcount for each band, derived from the hire dates in B2:B13.

The recommended pattern is a per-band SUMPRODUCT that DATEVALUE-coerces the hire-date strings into serials before comparing — bounded bands multiply two boolean arrays, the open-ended 5y+ band uses a single comparison:

E2 (0-1y):  =SUMPRODUCT((DATEVALUE($B$2:$B$13) >= DATE(2025, 6, 1)) * (DATEVALUE($B$2:$B$13) < DATE(2026, 6, 1)))
E3 (1-3y):  =SUMPRODUCT((DATEVALUE($B$2:$B$13) >= DATE(2023, 6, 1)) * (DATEVALUE($B$2:$B$13) < DATE(2025, 6, 1)))
E4 (3-5y):  =SUMPRODUCT((DATEVALUE($B$2:$B$13) >= DATE(2021, 6, 1)) * (DATEVALUE($B$2:$B$13) < DATE(2023, 6, 1)))
E5 (5y+):   =SUMPRODUCT(--(DATEVALUE($B$2:$B$13) < DATE(2021, 6, 1)))

Why SUMPRODUCT and not the more obvious COUNTIFS? Because the spreadsheet engine here loads CSV date cells as text, and COUNTIFS' >=/< comparators won't cross-type-coerce string-typed cells against numeric DATE() criteria — the count would silently come back 0. SUMPRODUCT with explicit DATEVALUE($B$2:$B$13) coerces the range to serials first, then the comparisons work as expected. (In real Excel, COUNTIFS would work too because Excel typically stores parsed dates as serials directly.)

These four formulas don't drag-fill — each band has its own pair of thresholds — but they each compute a single integer headcount.

Your task:

1. In E2:E5, write four SUMPRODUCT formulas (one per row) that compute the headcount for each tenure band.
2. The four numbers should match the four bars on the chart.

Graded cells: E2 (0-1y → 2), E3 (1-3y → 3), E4 (3-5y → 3), E5 (5y+ → 4).