Date Percentage Formula Help

I need help with a formula. I have two date-formatted columns ("Archives Start Date" and "Archives End Date") and I need a formula that displays essentially "as of today, we're X% of the way between those two dates".

Any help is greatly appreciated.


Best Answer

  • Leibel S
    Leibel S ✭✭✭✭✭✭
    Answer ✓

    @Nicole J

    Try this:

    =IF([Archive End Date]@row > [Archive Start Date]@row, MAX(MIN((([Archive End Date]@row - [Archive Start Date]@row) - ([Archive End Date]@row - TODAY())) / ([Archive End Date]@row - [Archive Start Date]@row), 1), 0), "End Date is before Start Date")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!