!It is necessary to count the number of days between two dates with the exception of the dates in the list.
NetWorkDays is not suitable because it excludes Saturdays and Sundays, and that if the company sometimes works on Saturday and Sunday.
That is, I need to calculate the days between two dates excluding dates only from my list.
A possible approach would be to create a master calendar, flag the dates you want to include / exclude in your calculation.
Then count the flagged dates in the master calendar that fall between the two dates.
May be something like this with new column u can try:
=if(weend or holiday<=Date of code,(num(date of code)-num(date start)-count(weekend or holiday)))
Plss alter if condtn as per need.