Displaying the lowest value for the next x days of data

I have a query that I am struggling to find/work out the answer to:

I am working on a basic spreadsheet to show financial value forecasts (account balances) over the course of the current month. Over the course of a month, a number of payments come in, meaning that the balance fluctuates. I want to be able to display the lows, as a guide to how low the balance will get before the next payment.

In Row 1, I have dates for the current month.
In Row 2, I have a numeric value for each date (the balance).

(Sorry about the formatting here - I couldn't work out how to do a table, so I've put the column letters in brackets along side each value.)


1| (A)1/2/17 (B)2/2/17 (C)3/2/17 (D)4/7/17 (E)5/2/17 (F)6/2/27 (G)7/2/17 (H)8/2/17 (I)9/2/17 (J)10/2/17 etc.
2| (A)10.....(B)8......(C)7......(D)9......(E)7......(F)5......(G)2......(H)1......(I)12.....(J)10.....etc.

PROBLEM

I'm currently using conditional formatting to show lowest balances as red, through the colour scale to green for the highest balances. All, good, but means I have to scroll through all columns to see the key values. Doing a simple =MIN for the range is good until the date of that balance has passed, at which point, it becomes irrelevant.

GOAL(S)

* I want to display the lowest balance for the next 7 days (discounting any value where the date in Row 1 is less than today)

SO if today is 1/2/17 then display the value in H2

* I want to display the lowest balance for the remainder of the month (discounting any value where the date in Row 1 is less than today);

SO if today is 1/2/17, then display the lowest value from the full month - assume H2 is the lowest here

BONUS:

* I want to display the lowest balance X days, where X is the number of days between TODAY and the next date where there is an increase from one cell to the next;

= if today is 1/2/17, then display the value in C2,
SO if today is 4/2/17, then display the value in H2

I'm not particularly advanced in my macros/VBA abilities, so if there is a formulaic way of doing this, that would be great!

TIA

A sample file is much better and is the value in d1 a typo?

OK - thanks for the tips - I'll attach a sample soon - your help is much appreciated!