count of Tickets excluding week ends(Sat,Sun)

[Anonymous]

date	tickets
05/01/2015	10
05/23/2015	20

Hi Gurus,

Excluding Sat ,sun days i want to count no of tickets created in selected Period

Thanks

[tresesco]

Something like:

=Sum(if(Not Match(Weekday(date),'Sat','Sun'),tickets))

[kaushalview]

Hi Babu

Use Networkdays dunction as mentioned below

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

Regards

Kaushal

[pokassov]

Hello!

count(if(num(WeekDay(date))<>5 and num(WeekDay(date))<>6, tickets))

[Anonymous]

Hi tresesco,

thanks for your time,its working fine .

but i forgot to include another condition

  i want to calculate last 30 days sum ,today-30 excluding (Sat,Sun)

thanks,

[#6]

Hi Are Babu, also you can do:

=count(if(WeekDay(Date)<>'sun' and WeekDay(Date)<>'sat', Tickets))

I attach the solution where I do the answer of you question.

Best regards,

Agustìn !

[Anonymous]

hi thnks for your time ,

your counting holidays but i need to exclude holidays and show last 30 days data (Excluding sat,Sun)

Thanks,

Babu

[maxgro]

a little change to tresesco‌ answer

=Sum({$ <date={"<=$(=Today())>=$(=date(Today()-30))"}>} if(Not Match(Weekday(date),'sat','sun'),tickets))

[Anonymous]

Hi massimo Grossi,

Its working fine but today ()-4 its doing sum only 3 values(excluding Sat,Sun).

I want to sum last 4 values excluding sat,sun

how to achieve this

PFA

Thanks,

Babu

[maxgro]

maybe you can try with

add a date serial field to your table 1, 2, 3, 4, etc.... but skip (set -100) the sat sun

n          fri

-100     sat

-100     sun

n+1      mon

....

and replace in set analysis

=Sum({$ <dateserial={"<=$(=max(dateserial))>=$(=max(dateserial)-30)>"}>}  tickets)