Hi All,
I have a list of contracts with all different start and end dates. Could be any date. I would like to see per contract for which quarter(s) they are valid.
Also if a contract is just 2 days open in a quarter, I need to mark them as YES open in that quarter.
See below table. Any nice formula to get these yes/no's?
<tbody>
</tbody>
I have a list of contracts with all different start and end dates. Could be any date. I would like to see per contract for which quarter(s) they are valid.
Also if a contract is just 2 days open in a quarter, I need to mark them as YES open in that quarter.
See below table. Any nice formula to get these yes/no's?
Contract | Start date | End date | Q1-16 | Q2-16 | Q3-16 | Q4-16 | Q1-17 | Q2-17 | Q3-17 | Q4-17 |
A | 01-01-2016 | 01-05-2016 | Yes | Yes | No | No | No | No | No | No |
B | 10-04-2016 | 15-10-2016 | No | Yes | Yes | Yes | No | No | No | No |
C | 01-08-2016 | 10-01-2017 | No | No | Yes | Yes | Yes | No | No | No |
<tbody>
</tbody>