# # 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.

• We can accomplish this using IF statements.

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

Does this work for you?

Kelly

• We can accomplish this using IF statements.

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

Does this work for you?

Kelly

• Hi Kelly,

When I applied this formula all seems to be working except the value when the received date and decision date are the same. The value is then a negative 2.

• I tried it with a new entry and it does seem to be working now. Thank you for the assist.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!