Consulting

Results 1 to 4 of 4

Thread: Count Dates in a List of dates for every employee for every month

  1. #1

    Count Dates in a List of dates for every employee for every month

    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.
    03-06-2021 13-29-33.jpg

    The engineer column and arrive date columnsNSP DUMP-Y1 2020.xlsx are highlighted in the attached file, please support with a formula to arrive each engineer worked days in that month.

    Thanks in Advance

    Raj

  2. #2
    VBAX Expert
    Joined
    Sep 2016
    Posts
    783
    Location
    Pivot table

  3. #3
    Hi Mana,
    Pivot table is not the solution, i have figured it out myself. =SUM(IF(FREQUENCY(IF(Engineer=A4,Worked_Days),Worked_Days),1)) has given me result.

    Raj

  4. #4
    Moderator VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,704
    Location
    Thank you for sharing the solution. I'm sure it will help many people.
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •