Sheet1:
<tbody>
</tbody>
Sheet2:
<tbody>
</tbody>** In column B, I used data validation to create a list: 1, 2, 3
Sheet1 defines start and end date for each block. In column B of Sheet2, I'm hoping to generate either 1, 2, or 3 depending on the date entered in column D of Sheet2. So B1 would be 1, B2 would be 3, and B3 would be 2.
Any help will be much appreciated, thank you in advance
Block 1 | Block 2 | Block 3 |
2019-05-20 | 2019-05-23 | 2019-05-27 |
2019-05-22 | 2019-05-26 | 2019-05-31 |
<tbody>
</tbody>
Sheet2:
24 | Cat | 2019-05-21 | |
25 | Dog | 2019-05-27 | |
26 | Bird | 2019-05-24 |
<tbody>
</tbody>
Sheet1 defines start and end date for each block. In column B of Sheet2, I'm hoping to generate either 1, 2, or 3 depending on the date entered in column D of Sheet2. So B1 would be 1, B2 would be 3, and B3 would be 2.
Any help will be much appreciated, thank you in advance
Last edited: