Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Count between from and to date

Hi, 

 

I need to show in a table/matrix the days someone is gone based on from and to date:
Dataset includes datetable.

 

The dataset looks somewhat like this (3 columns):
Person    from               to
1             03.02.2020     07.02.2020
2             04.02.2020      07.02.2020

Desired matrix:
Weeknr 6  
day                Mon   Tue    Wed    Thu   Fri    Sat  Sun
person 1        1          1        1         1        1           
person 2                    1         1         1        1        



 

 

4 Replies