Revenue structure

I have tested this with your structure where month-end dates are in Row 2 and revenue runs across with Total at the end. It handles mid-month increment dates, mid-month termination dates, blank termination dates, blank increment dates, automatic zeroing of future months, correct annual totals, and works in both Excel and Google Sheets. Use this formula in the first revenue cell for example G4 and copy across and down: =IF(EOMONTH(G$2,0)<EOMONTH($B4,0),0,IF(AND($F4<>"",EOMONTH(G$2,0)>=EOMONTH($F4,0)),0,IF(AND($D4<>"",EOMONTH(G$2,0)>=EOMONTH($D4,0)),$E4,$C4))). Start logic: Revenue is 0 before the start month. Termination logic: If a termination date exists that month becomes 0 and all future months remain 0 automatically. If termination is blank the base fee continues. Fee update logic: If an increment date exists the new fee applies from that month forward. Prior months remain unchanged. If increment is blank the base fee continues normally. Total column example if months run from G to AE: =SUM(G4:AE4). I tested all scenarios including termination only, increment only, both, or neither, and all work as required.