Forum Discussion

Mickey966's avatar
Mickey966
Copper Contributor
May 14, 2024

Worked days in a month?

  Hi everyone,   What formula can I use to determine how many days that employee worked in that month? my issue is that there could be multiple cells in 1 day. Thanks  
  • HansVogelaar's avatar
    May 14, 2024

    Mickey966 

    For example:

     

    =COUNT(UNIQUE(FILTER(Report_Date_Range, Surveyor_Range="Mickael Clavreuil")))

Resources