Sheet1:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]Block 1[/TD]
[TD="align: center"]Block 2[/TD]
[TD="align: center"]Block 3[/TD]
[/TR]
[TR]
[TD="align: center"]2019-05-20[/TD]
[TD="align: center"]2019-05-23[/TD]
[TD="align: center"]2019-05-27[/TD]
[/TR]
[TR]
[TD="align: center"]2019-05-22[/TD]
[TD="align: center"]2019-05-26[/TD]
[TD="align: center"]2019-05-31[/TD]
[/TR]
</tbody>[/TABLE]
Sheet2:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]24[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Cat[/TD]
[TD="align: center"]2019-05-21[/TD]
[/TR]
[TR]
[TD="align: center"]25[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Dog[/TD]
[TD="align: center"]2019-05-27[/TD]
[/TR]
[TR]
[TD="align: center"]26[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Bird[/TD]
[TD="align: center"]2019-05-24[/TD]
[/TR]
</tbody>[/TABLE]
** 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
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]Block 1[/TD]
[TD="align: center"]Block 2[/TD]
[TD="align: center"]Block 3[/TD]
[/TR]
[TR]
[TD="align: center"]2019-05-20[/TD]
[TD="align: center"]2019-05-23[/TD]
[TD="align: center"]2019-05-27[/TD]
[/TR]
[TR]
[TD="align: center"]2019-05-22[/TD]
[TD="align: center"]2019-05-26[/TD]
[TD="align: center"]2019-05-31[/TD]
[/TR]
</tbody>[/TABLE]
Sheet2:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]24[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Cat[/TD]
[TD="align: center"]2019-05-21[/TD]
[/TR]
[TR]
[TD="align: center"]25[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Dog[/TD]
[TD="align: center"]2019-05-27[/TD]
[/TR]
[TR]
[TD="align: center"]26[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Bird[/TD]
[TD="align: center"]2019-05-24[/TD]
[/TR]
</tbody>[/TABLE]
** 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
Last edited: