count if unique date
I am using a check box in an install list that once the box is checked it records a date. Then using the formula =IF(ISDATE([Install Date]@row), COUNT(DISTINCT([Install Date]$2:[Install Date]2)), "--") to assign the day or days that we have installed in total. SO if we install 15pcs on 9/20/23 than all 15 will show 1. The pcs installed on 9/21/23 would show 2. My struggle is, when we have to skip out of order due to issues onsite the numbers get a little messy. How would I adjust my formula to capture this?
Help Article Resources
Check out the Formula Handbook template!