Number of days between 2 dates ignoring errors

Hi. I need to return the number of days that have lapsed between 2 dates, but to ignore errors and return nothing. Here is what I am trying and it seems to work but its putting a - in front of the count. Opp Approved Date is always prior to Live Date. I would like to display without the negative in front if possible. Thank you in advance.

=IFERROR(NETDAYS([Live Date]@row, [Opp Approved Date]@row), "")

Best Answer

  • Anjanesh Vaidya
    Anjanesh Vaidya ✭✭✭✭
    Answer ✓

    Hi Eenmeier,

    You can try following formula in the sheet summary.

    =AVERAGEIF([Live Date]:[Live Date], AND(MONTH(@cell) = 1, YEAR(@cell) = 2024), [Dates to live]:[Dates to live])

    You can specify the year and the month accordingly by modifying the formula.

    I hope it will work.


    Anjanesh Vaidya


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!