Absolutely, Sample data below:
Sample table 1: submissions by date / employee (plus some additional columns of information not relevant to this task):
note: dates are always the last 6 mondays.
note: there are over 150 employees in the real dataset.
Sample Table 2: A list of all employees submitting data (plus some supplementary columns not relevant to this task):
note: each employee only has one record in this table, there are no duplicates
Expected output table: TRUE / FALSE for submissions by employee / week
My only other note is that an employee can and usually will submit more than one record of information per date. But here we're only interested in flagging if an employee has submitted anything at all. The final output for reporting would filter out any TRUE values, leaving us with this: