rajkumar
06-03-2021, 01:06 AM
Hi Experts,
I need a formula to arrive at number days that an employee has worked in a given month. There may be three or four customer visits he would have done on a single day, but the count for days has to be taken as 1 only like his attendance. Ex: if there are 3 entries of 02/01/2021 for Engineer A then the count of date should be 1 only for that month.
28568
The engineer column and arrive date columns28569 are highlighted in the attached file, please support with a formula to arrive each engineer worked days in that month.
Thanks in Advance
Raj
I need a formula to arrive at number days that an employee has worked in a given month. There may be three or four customer visits he would have done on a single day, but the count for days has to be taken as 1 only like his attendance. Ex: if there are 3 entries of 02/01/2021 for Engineer A then the count of date should be 1 only for that month.
28568
The engineer column and arrive date columns28569 are highlighted in the attached file, please support with a formula to arrive each engineer worked days in that month.
Thanks in Advance
Raj