Report- Date filter for WorkDays only


I have created a report that gets sent to data entry specialists every morning. The report is set to only pull data and only send if there is an entry with a submission date in the last 1 day. In the report I am using the WHEN? filter and have it set as Date is in the last 1 day.

This logic fails on Mondays because data is never added on Sat or Sundays. The problem is that I will be missing data from Fridays since Monday's report only shows the day prior.

Does anyone know if there is a way to set workdays on a grid sheet and report? I know how to set work days for a project but this report is running from a basic sheet and not a project.

Best Answer