Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
!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 like:
U convert you both dates in to number and deduct them.
And then take the count of days from ur list and again deduct from above result.
Sachin
See the attachment, imagine that the 50 million lines
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.
Anothr condion in else should be like:
Simple date of code- start date.
While u try u use num() on all date fileds n compare.
