Forum Discussion

Mickey966's avatar
Mickey966
Copper Contributor
May 14, 2024
Solved

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

 

1 Reply

  • Mickey966 

    For example:

     

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