I’m trying to get a cell to change its value based on a date range.
Let's say I have this list:
A B date1 10 date2 25 date3 50 date4 85
On date1 I will have 10 items, date2 I will have 25 etc.
What I’m trying to do is if today's date is after (or on) date1 but before date2, input date1's value from B. Then, once we hit date2, input date2's value from B.