Largest Gap Between Dates?

Options

Hi . I have a column which contain dates. Is there a formula that would:

  1. Return the largest gap between the dates in the column?
  2. Return the dates?

My column contains dates of call logs. I want to see the largest gap that occurred (for example, we didn't call anyone for 7 days). I also want to see the two dates used to calculate the largest gap.

So for the above, the largest gap between dates would be between 01/05/24 and 01/30/24 (25 days).

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!