crispangilinan
New Member
- Joined
- Sep 16, 2021
- Messages
- 9
- Office Version
- 365
- 2019
- 2016
Hello! I need assistance in creating a formula that will lookup an employee's schedule based on:
1. Employee name
2. Schedule per Date range (start / end date)
3. Employee can have different schedule weekly that is why date range is important
3. Check if employee is on pto (start / end date)
4. Raw data indicates if the employee will work each day (E.g. Mon - Yes, Tues - Yes, Wed - No)
Technically, if i enter a date, the report should be able to output the employee schedule that day and tell if employee is on leave. We are talking about atleasr 300 employees. I would like to see all of their schedule depensing on the date i choose.
1. Employee name
2. Schedule per Date range (start / end date)
3. Employee can have different schedule weekly that is why date range is important
3. Check if employee is on pto (start / end date)
4. Raw data indicates if the employee will work each day (E.g. Mon - Yes, Tues - Yes, Wed - No)
Technically, if i enter a date, the report should be able to output the employee schedule that day and tell if employee is on leave. We are talking about atleasr 300 employees. I would like to see all of their schedule depensing on the date i choose.