I’ve created a simple form that our staff can use to log when an employee is absent.
This works great as every morning our managers fill out the form for the staff absent/on leave/working remotely etc. I then have a sheet which filters by the date column “today” to display the staff.
However if an employee is on leave for let’s say a week, we have put in two date picker fields example:
Is there a formula which will filter the employees name as long as the date appears on/between the two date fields.