Days Until Each Employee's Next Work Anniversary

You're an HR analyst building a "next anniversary" alert column for the leadership team. Column C (Hire Date) has 12 employee hire dates; you need column D (Days Until Next Anniversary) populated with the integer number of days from a fixed "as-of" date to each employee's next work-anniversary date.

Use 2026-06-01 as the literal "as-of" date — =DATE(2026, 6, 1) — so the math is deterministic for grading. Anniversaries that have already occurred this year (e.g., a March hire date when the as-of is in June) roll forward to the next calendar year.

Worked example: Hire Date 2020-09-15, as-of 2026-06-01. The 2026 anniversary (2026-09-15) hasn't passed yet, so the answer is the day-count from 2026-06-01 to 2026-09-15 = 106 days. For a March hire date, the 2026 anniversary already passed (March is before June), so use the 2027 anniversary instead.

The recommended formula uses LET to bind the as-of date once and the same-year-anniversary date once:

=LET(
  today, DATE(2026, 6, 1),
  thisYear, DATE(YEAR(today), MONTH(C2), DAY(C2)),
  IF(thisYear >= today, thisYear, DATE(YEAR(today) + 1, MONTH(C2), DAY(C2))) - today
)

The IF picks the upcoming anniversary (this year if it hasn't passed yet, next year otherwise); the subtraction yields an integer day count because both operands are date serials.

Your task:

1. In column D (Days Until Next Anniversary), write a formula that returns the integer day count for each row.
2. The formula must drag-fill from D2 → D13.

Graded cells: D2 (2020-09-15 → 106), D6 (2021-05-30 → 363 — one of the "anniversary already passed; use next year" cases), D11 (2024-04-18 → 321).