Days Until Next Task Due


I have a column of upcoming task due dates, and would like to compute the number of days until the next upcoming task. I have read about =MIN(COLLECT but can't seem to get the formula correct. I know the >TODAY function should be included in the formula somewhere as well.


Best Answer

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Answer ✓

    @Danielle Ferrari

    Finish:Finish is the column of the Dates

    Are you insert the formula in a Date column type, because if you insert it in text / number column type will not work

    PMP Certified

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"