cumulative value between dates

I have a table with column A for dates, and column B for values.

 

A

B

1/1/17

10

2/1/17

2

3/1/17

0

4/1/17

6

5/1/17

3

6/1/17

4

 

 

 

I know how to use the SUMIF formula to obtain the cumulative value between any two dates.  So if I have A2 (2nd January) and A5 (5th January) I obtain a value of 2+0+6+3 = 11.

 

My question is this,  if I have the starting date (ex. A2 or 2nd Jan) and I know the cumulative value (that is 11)  how do I formulate to obtain the second date? (5th January) at the nearest lesser or higher value, when value is not exact?

 

I tried using offset, index, match etc, but so far it did’nt work out.  Thanks for your help!

    

By: Edward Grech

Leave a Reply

Your email address will not be published. Required fields are marked *