Hi, decided I've spent enough time fumbling with this, time to ask for help.
The RED section or 'criteria range 2' of this sumifs formula is what I need some help on.
Column H = Duration in weeks, $H$6:$H$104
Column F = Start Date Range, $F$6:$F$104
Hypothetical 'End Date' column would equal...