Formula for difference between 2 dates excluding sunday & 2nd saturday.

[Vivek2705]

A1 = Date 1
A2= Date 2

I want a formula to know the difference between 2 dates (A1-A2) excluding sunday, 2nd & 4th saturday...if the difference is upto 4 working days then true else false..

I tried workday.intl formula & excluded only sunday but didnt got the way to exclude 2nd & 4th saturday..

Thanks..

[AliGW]

You will need to add to the formula a calculation of the number of Saturdays that meet this criterion and take it away from the total, or you could create a table with these 2nd and 4th Saturdays defined as holiday dates and use the range as the holiday array.