I want to count the number of weekends between two dates.
Do you have a solution for this demand ?
Thanks a lot
Go to Solution.
See if this works for you...
Create a SYS Time module by Day with the following line items:
Day Nbr of Week: WEEKDAY(Date)
Count Saturdays: IF Day Nbr of Week <> 6 THEN 0 ELSE 1
In another module that is not dimensionalized by Time, you have 3 line items:
Date1: date formatted that is entered
Date2:date formatted that is entered
Number of Weekends:TIMESUM('SYS Time Filter - Day'.Count Saturdays, 'Date 2', 'Date 1')
Hope this works for you,
View solution in original post
ROUND(('Date 2' - 'Date 1') / 7)
Thanks a lot.
It worked for me, I did some modifications. It fits my need.