Counting unique dates

Hi

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.

Thanks



Answers

  • Sameer Karkhanis
    Sameer Karkhanis ✭✭✭✭✭✭

    Isn't the formula for the column "Days on Hold" already doing that? Btw, you value in "Unique Hold Days" last row is incorrect, should be 2 and if not, how did you get the values 9 and 5 for others?

  • Cathy Byrne
    Cathy Byrne ✭✭✭

    I've typed them manually into the sheet - the reason the third row is 1 is that's the unique day it was on hold the 10/02/21 I don't want to count the 09/02/21 as that date is included in row 2. I only want the unique days it's on hold to be counted or it'll say it's on hold for 16 days but due to duplicate days it's actually only 15 days.

    This is a small example of the data I have, most overlap for about 20 days so it really puts the data out if it counts days twice.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!