Counting unique dates
I would like a formula that just counts the unique days when multiple dates are entered, they don't always overlap so I can use the min and max function. Like below there's no "active" for the 1st & 2nd Feb so these dates shouldn't be counted. I've added the column Unique Hold Days as this is the result we're after.
Help Article Resources
Check out the Formula Handbook template!