Final V1.0.xlsx
Dear All,
I need help of experts. I am making Gantt Chart(Project progress chart). One the second sheet I manage the Leaves of employee working on that project. See the attached file.
I want to count the number of leaves of an employee between two starting and ending dates of a project. I am not able to call countif or countifs function. Please help me to fill the J6 column automatically according the requirement I mentioned above:
Please see the attached file for reference
Bookmarks