Hello all,

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:

Date From

Date To

Is there a formula which will filter the employees name as long as the date appears on/between the two date fields.

Thanks!