Im trying to get a cell to change its value based on a date range.Let's say I have this list:A        Bdate1    10date2    25date3    50date4    85On date1 I will have 10 items, date2 I will have 25 etc.What Im 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.
Change contents of cell based on date range in Google spreadsheet
google spreadsheets