exclude Saturday and Sunday rollover to 30 days

[Anonymous]

I want to calculate Number of tickets 5 days in a week (exclude Saturday and Sunday) from today to last 30 days

please anybody help me out..

Thank You..

[#2]

hi,

one option is that you can use  networkdays function it will give only working days(Monday to Friday).

networkdays ('2007-02-19', '2007-03-01') returns 9 

Second---> you make a table with resident of master table and count the saturday and sunday .

after that  use sum (total dasy)-sum(saturday+sunday)

Regards

Vimlesh

[Anonymous]

Networkdays function is not working...we should have calculate from today to last 30 days and should have exclude sat and sun ..this will happen everyday..

[#4]

Hi,

See this app may be useful to you.

put today() at the place of Date2.

According to your need .

Regards

Vimlesh