Hi,
I have an excel table as in the image:
<tbody>
</tbody>
So my questions are:
Thanks indeed for your precious helps.
I have an excel table as in the image:
A | B | C | D | E | F | G | H | |
1 | Start Date | End Date | Price | Season | ||||
2 | 01.05.2019 | 15.05.2019 | 10 | A | Start Date | 03.05.2019 | OR | 13.05.2019 |
3 | 16.05.2019 | 06.06.2019 | 20 | B | End Date | 10.05.2019 | 20.05.2019 | |
4 | 07.06.2019 | 03.07.2019 | 30 | C | ||||
5 | 04.07.2019 | 31.07.2019 | 40 | D | Price | 70 | 110 | |
6 | 01.08.2019 | 21.08.2019 | 50 | E | ||||
7 | 22.08.2019 | 10.09.2019 | 40 | D | ||||
8 | 11.09.2019 | 05.10.2019 | 30 | C | ||||
9 | 06.10.2019 | 31.10.2019 | 10 | A |
<tbody>
</tbody>
So my questions are:
- How can I fix the formulas in F5 & H5 (to calculate the price between the selected dates even in one period or in a breaking period (H5; 3 days from season A and 4 days from season B)?
- What can be the formula in column D (D2:D9) to assign the same letter if price is same?
Thanks indeed for your precious helps.