I have 2 lists that I use to create an Absence Planner for our workplace. 1 list has the absence types, start and end dates. The second list has the members names and work area the belong to. This works very well.
What I a trying to do is create a separate list view to show what members have not made an entry for [Today] and the previous 20 days (rolling) not including week ends.
eg. in the below example for the 13th Nov 2020 both Fred and Mary would appear on the list as they do not have an entry that covers 13th Nov 2020 and Tom would not show on the list because he has an entry that covers the 13th Nov 2020. I would like the list to group by work area.
| Member | Absence Type | Work Area | Start Date | End Date |
| Fred | Annual | Office | 02 Nov 2020 | 12 Nov 2020 |
| Fred | Personal | Office | 16 Nov 2020 | 30 Nov 2020 |
| Mary | Personal | Workshop | 05 Nov 2020 | 12 Nov 2020 |
| Mary | Annual | Workshop | 16 Nov 2020 | 19 Nov 2020 |
| Tom | Annual | Workshop | 02 Nov 2020 | 20 Nov 2020 |
Thanks
