# of days between two dates

I manage an intake process and I am trying to determine the number of days between two dates (received date and decision date). That piece of it is pretty simple. There are two parts that I cannot figure out.

  1. If the decision date has not been set, the cell for number of days shows an error. I want the cell blank until the decision date has been set.
  2. If the received date and decision date are the same day, I want the # of days to equal 1.

Best Answer

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓

    Hey @tiffany stephenson

    We can accomplish this using IF statements.

    =IF(ISDATE([Decision Date]@row), IF(NETDAYS([Received Date]@row, [Decision Date]@row)=0, 1, NETDAYS([Received Date]@row, [Decision Date]@row)))

    If you're using a different NetDays formula, swap it into the formula instead of NetDays.

    Does this work for you?

    Kelly

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!