MS excel formula for employee leave planner

I want to create an excel sheet to schedule employee annual planner.

If anyone submits leave application, while entering i need to find anyone applied for these date range. And also compared it with their respective designations.

can anyone help me to sort out this.....