Count how many Tuesdays between 2 dates

[richard_chilvers]

Is there a smart way of counting the number of Tuesdays there are between 2 dates ?

Thanks

[lironbaram]

Hi 
this expression should work for you 

=sum(if(weekday(dateField)=2,1,0))

You need to replace "dateField" with your actual date field.

[richard_chilvers]

Thank you.

I guess I can use set analysis to define the date range I'm interested in ?

[marcus_sommer · Accepted solution]

You may apply it in this way:

count({< [Weekday] = {2}>} [Date])

whereby weekday must exists as a native field within the data-model which is usually the case by using a master-calendar.

- Marcus