Networkdays function to change non working days from saturday-sunday to thursday-friday

[#1]

Hi Folks,

I have a requirement where we need to calculate the no of days between start date and end data.

We can use the

networkdays( start:date, end_date {, holiday} )

but this function automatically excludes saturday and sunday.

What i need is to exclude Thurday and Friday as non working days and include the saturday and sunday as working day while doing the calculation.

Our client working days are Sat-Wed  and Thu-Fri as weekOff.

So how can i use an logic to calculate the exact no of days.

Please advise how to achieve it.

Your suggestion is much appreciate.

Regards

[#2]

Best way is take a primary key field from your data model tables..

And write the expression like

if(count(primarykey)>0 ,count(distinct date))

then it will display the working days of your customer data regardless sun,wed...etc