Hi,
I have an annual budget that contains all the days in year, and various formulas calculating values.
That bottom row of the table has a simple indicator to show if the day is in the past.
Please see the attached demo of the layout...
demo.xlsx
I want a formula to create a dynamic range from "tomorrow" to the end of the sheet (J:V in the example) but this will move as the date changes.
I will then use that range to return the 3 smallest values (A7:A9 in the example as today is 8th July), but I also want it to return the date that small value occurs on (B7:B9 in the example). If the small value occurs more than once, that it just needs to return the first and associated date.
Row 1 contains the date to report, row 4 contains the balance to check and row 5 contains the day indicator.
Many thanks.
Bookmarks