How to calculate an average cliff date?
You would indeed need to calculate the difference in days between the Date Entered and the Date Closed column. You can then either (1) group directly by the number of days and look at the percentage of records where the Status is equal to Open or Lost or (2) first create buckets and then perform the same step as in (1). You are then free to choose the percentage which you feel equals &quot;likely&quot; (50%, 80%, 99%?) and then use the difference in days as the threshold.