Count of Dates excluding sat and sun

[Vijen_M]

i have date from ist jan 2020 to 14 feb 2023 and i want to count date excluding first and second saturday of Month and all the sundays  ? please help asap 

[ogster1974 · Accepted solution]

in your master calendar add something like.

If(weekday(tmpDate)=6 or (weekday(tmpDate)=5 and day(tmpDate)<=14),1,0) as Exclude_Flag

[Vijen_M]

Hi @ogster1974  thank you for your response from this i have got the answer .

i have done this in another way please review it if it's right 

(Count({$<WeekDay={'Sat'},Day={'(<=14)'}>}Date)) + (Count({$<WeekDay={'Sun'}>}Date))

from this i am getting same output

[ogster1974]

Yes you can use set analysis to do this. The question is where do you want
the calculation processing to be done on the back end where the user won't
notice or the front end where as you scale up your user may have to wait
for it to execute.

I tend to use set analysis calculations only when the users selections make
an impact to its result.

In this case a flag set in the back end is sufficient hence my solution.