Excel: Formula to return date if cumulative amount meets criteria


I have 2 columns for dates and amounts paid I want a formula which will determine the date when the cumulative of the amounts just exceeds or equals a given value. So suppose I have the following: Dates Amt 16-Jul-14 10000 1-Aug-14 4567 3-Aug-14 3000 Now suppose I have 14,000 as my "cut-off" amount. I want a formula which should return the date, 1-Aug-14 as the cumulative amount until 1-Aug is 14,567 which is just above the cutoff of 14,000. The formula should not return 3-Aug-14 even though it meets the criteria. Thanks


This question generated 14 answers. To proceed to the answers, click here.

This thread is current as of August 20, 2014.


For more resources for Microsoft Excel