Backdgroud: we need the days which except the first two days in a week. since the first two days is free. others will be charged.
the question is how to find number of the days except the first two days.
the data is discontinuous
| 1/31/2022 | 2/3/2022 | 2/7/2022 | 2/8/2022 | 2/10/2022 | 2/14/2022 | 2/17/2022 | 2/21/2022 | 2/24/2022 | 2/28/2022 |
| 0 | 3 | 7 | 8 | 10 | 14 | 17 | 21 | 24 | 28 |
i usually compare above data with below data to find the days that except the first two days.
| s | s | m | t | w | t | f |
| | | | | | | |
| 0 | 1 | 2 | 3 | 4 | 5 | 6 |
| 7 | 8 | 9 | 10 | 11 | 12 | 13 |
| 14 | 15 | 16 | 17 | 18 | 19 | 20 |
| 21 | 22 | 23 | 24 | 25 | 26 | 27 |
| 28 | | | | | | |
in this case, 2/10/2022 is the third day.
how can i use formulas to get this result. i only need the number of days that except the first two days in a week. it will be very useful if i can use the formulas,
in that case, it will save time. and reduce errors.
many thanks.
