Debug — Subscription Renewal Lands a Month BEFORE Start

A billing analyst's subscription-renewal column is producing dates a month BEFORE the start date instead of after — a customer who started on 2026-01-15 is being told their renewal is 2025-12-15. Their original formula in column C:

=TEXT(EDATE(DATEVALUE(B2), -1), "yyyy-mm-dd")

The bug is the -1 in EDATE. EDATE's second argument is the number of months to add — positive for the future, negative for the past. The original code is asking for "1 month before the start date" rather than "1 month after."

The fix: flip the sign from -1 to 1:

=TEXT(EDATE(DATEVALUE(B2), 1), "yyyy-mm-dd")

(The DATEVALUE(B2) wrap is necessary because the spreadsheet engine here treats CSV-loaded date cells as text strings, and EDATE only accepts numeric date serials. DATEVALUE coerces the ISO string to the serial EDATE wants. Without it both formulas would return #VALUE!.)

EDATE is the right function for monthly arithmetic because it correctly handles month boundaries (2026-01-31 + 1 month = 2026-02-28, not 2026-02-31) and year rollover (2026-12-25 + 1 month = 2027-01-25).

The data at B2:B13 has 12 customer subscription start dates. The fix should produce a YYYY-MM-DD string that's exactly one calendar month after the start.

Your task:

1. In column C (Next Renewal), write a corrected formula that returns the renewal date as a yyyy-mm-dd string.
2. The formula must drag-fill from C2 → C13.

Graded cells: C2 (2026-01-15 → 2026-02-15), C5 (2026-04-10 → 2026-05-10), C13 (2026-12-25 → 2027-01-25 — verifies year rollover).