HI EVERYONE,
i have a work tracking file in which every work is planned to the date on which it has to be done. we have whole year work planned in the sheet. every department has its own work (there are currently 3 departments 1.admin 2.maintenance 3.security). the problem is that sheet is too long and so i want that there should be 3 parameters (1 department 2 starting date 3 end date. (please see sheet admin) result should be shown up according to the date. it means when we change dates in c1 or d1 result should be according to those dates.

and what i am asking for is in sheet "desire result". thanks in advance. here is the link of file.
https://docs.google.com/spreadsheets...dit#gid=998613