Forum Discussion
Mickey966
May 14, 2024Copper Contributor
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
For example:
=COUNT(UNIQUE(FILTER(Report_Date_Range, Surveyor_Range="Mickael Clavreuil")))
For example:
=COUNT(UNIQUE(FILTER(Report_Date_Range, Surveyor_Range="Mickael Clavreuil")))