the count the days which except first two days in a week.

Occasional Visitor

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/20222/3/20222/7/20222/8/20222/10/20222/14/20222/17/20222/21/20222/24/20222/28/2022
03781014172124

28

 

i usually compare above data with below data to find the days that except the first two days.

ssmtwtf
       
0123456
78910111213
14151617181920
21222324252627
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.

0 Replies