I have a large dataset with many employee names. I am trying to count the distinct dates based on employee for a specific date range. Some names will have many entries for the same date, so I want to know the number of days within a month that have entries. I can manipulate this with a pivot table but I need it to be with a formula. In the spreadsheet you will see I entered the results I want for each employee in D through H.
Bookmarks