ashish navale
New Member
Hi,
I have a production tracker which is used to maintain work done daily by employees in the project. There are multiple entries for same date in this excel. The thing is that my Manager wants week-wise attendance of employees in same excel but different sheet. There are four boxes named as 1st week, 2nd week, 3rd week, 4th week. In the boxes there are 2 columns. One is name of employees and other column is no.of days present in week.
I want a formula in column of No.of days through which I will get weekwise count of days present. Please help me out with a perfect solution.
I have a production tracker which is used to maintain work done daily by employees in the project. There are multiple entries for same date in this excel. The thing is that my Manager wants week-wise attendance of employees in same excel but different sheet. There are four boxes named as 1st week, 2nd week, 3rd week, 4th week. In the boxes there are 2 columns. One is name of employees and other column is no.of days present in week.
I want a formula in column of No.of days through which I will get weekwise count of days present. Please help me out with a perfect solution.