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
-
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?
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!