hello there- Hope you all are doing great
I want to calculate the # of selling days ( by week day- Mon, Tue,wed, Thurs, Fri) from a start date( including) to end date(including) .
Also, i want to exclude the holidays. examnple:
I want to calculate how many Mon,Tue, Fris' are between 5/23/2022 to 5/31/2022?
Total number
M: 2
T:2
W:1
T:1
F:1
But what I want to do is exclude the Holidays too. example: If May 30 is a holiday then I want Monday to be 1 ( and not 2).
Can anyone please help with this? i have attached my sheet with example.
Thanks a lot
Naina
I want to calculate the # of selling days ( by week day- Mon, Tue,wed, Thurs, Fri) from a start date( including) to end date(including) .
Also, i want to exclude the holidays. examnple:
I want to calculate how many Mon,Tue, Fris' are between 5/23/2022 to 5/31/2022?
Total number
M: 2
T:2
W:1
T:1
F:1
But what I want to do is exclude the Holidays too. example: If May 30 is a holiday then I want Monday to be 1 ( and not 2).
Can anyone please help with this? i have attached my sheet with example.
Thanks a lot
Naina