¿How to count Saturdays in date range?

[#1]

Hi there,

I need your help to solve my issue, i need to count saturdays in date range:

I have a field with date (Format: DD/MM/YYYY hh:mm:ss) and i make filters in diferents range but i need only count how many saturdays exist into this range selected (the range is variable).

Thanks for all!.

Thanks in advance.

[swuehl]

Maybe like shown here

Re: Count of Saturday in whole month

=Div(WEEKDAY(Min(DateField)-6)+1-Min(DateField)+Max(DateField),7)

[florentina_doga]

in script;

aa:

load *,

WeekDay(data) as week_name;

load * inline [data

1/1/2016

2/1/2016

3/1/2016

4/1/2016];

and in interface

count(distinct if(week_name='Sat',data))

[#4]

Does not work!

[MK_QSL]

Div(Date2-Date1,7) + (WeekDay(Date1)<=5)*(WeekDay(Date2)>=5)

[swuehl]

'Does not work' is not a really helpful issue description.

Do you get an error, no value, wrong value?

(I assume you have replaced DateField with the field name of your date field).

See attached a sample QVW.

[florentina_doga]

see this attach

[#8]

Does not work, this formule is counting 1 with any saturdays selected.

[tamilarasu]

Maybe try,

Count(If(Weekday(DateField)='Sat',1))

[smirkinaa]

Hi, I suggest to use additional field with number of weekday, which we have to add in the load script. And than you can use expression like this "Count({<WeekDayField = {5}>} DISTINCT DateField)". We have to use integer values in DateField. That's why we should use transformation for it: Floor(BaseDateField).