Finding the Date When the Number Goes Negative

An Excel file that teaches how to perform Contract Tracking Table operation.

Excel Spreadsheet for Finding the Date When the Number Goes Negative

Cumulative totals are tracked by row. The first negative result is captured by a conditional formula. The DATE and ROW functions are used together. Error conditions are handled gracefully. Ranges are dynamically expanded. The result is reported in a single cell.

Hope it is useful.