jkackley724
New Member
- Joined
- Sep 7, 2017
- Messages
- 1
I'm trying to write a formula that returns a specific date from an array based on two criteria.
Spreadsheet set up:
Row 1 A1:H1 (array of dates)
Row 2 A2:H2 (series of number, 0,4,8,12, etc.)
Column A3:A6 (series of numbers, 0,3,5,8,13,14, etc.)
I want to populate B4:B6 with dates, based on the numbers in A3:A6 and A2:H2. When the number in A4 is greater than the numbers in A2:H2 but also less than or equal to the numbers in A2:H2, I want that date returned. Example below, when 5 is between 4 & 8, I want the date when that occurs (January 31, 2018). Is this possible?
<tbody>
</tbody>
Spreadsheet set up:
Row 1 A1:H1 (array of dates)
Row 2 A2:H2 (series of number, 0,4,8,12, etc.)
Column A3:A6 (series of numbers, 0,3,5,8,13,14, etc.)
I want to populate B4:B6 with dates, based on the numbers in A3:A6 and A2:H2. When the number in A4 is greater than the numbers in A2:H2 but also less than or equal to the numbers in A2:H2, I want that date returned. Example below, when 5 is between 4 & 8, I want the date when that occurs (January 31, 2018). Is this possible?
12/31/2017 | 1/31/2018 | |
4 | 8 | |
5 | 1/31/2018 |
<tbody>
</tbody>