Dear Friend,
I think the following query will work for you:-
select EmployeeId from Employee where LeaveFromDate between @FromDate and @ToDate
where @FromDate is 4 Apriland @ToDate is 7 April in your case.
Add the above query in the stored proc you make.
Thanks