Calculating weekdays count in a month

[poojashribanger]

i have a date column and i want number of completed weekdays for a particular date

i.e.

1/12/2018--sat--1

2/12/2018--Sun--1

3/12/2018--Mon--1

......

17/12/2018--Mon--3

18/12/2018--Tue--3

.....

31/12/2018--Mon--5

i want to dynamically get the count of weekdays for a day till today

[OmarBenSalem · Accepted solution]

Suppose u have a date field, a weekday field and a month field:

use this expression:

aggr(rangesum(above( count({1}WeekDay),0,RowNo())),Month,WeekDay,MyDate)

result:

see if I select a weekday for example:

If I select a date: ; exaù^me 27/12/2018; I'd expect Jeu(thirsday) and 4 :