# of days between two dates

tiffany stephenson

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.

Kelly Moore

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

Kelly Moore

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

tiffany stephenson

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.

tiffany stephenson

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