NETDAYS Formula Question

Question

I have created a formula to track in progress orders by the number of days, =NETDAYS([Date Received]@row, TODAY())

I have the following columns created, Date Received, Date Completed, In Progress Days

This is a formula attached to the entire column, but I need cells for orders completed to stop counting as in progress.

Is there a way to stop days from counting once a date is added to the Date Completed column?

Melissa Yamada · Accepted Answer

Hello @jgrotti

How about something like this:

=IF([Date Completed]@row="", NETDAYS([Date Received]@row, TODAY()), NETDAYS([Date Received]@row, [Date Completed]@row))

Sandy Drew · Accepted Answer

Along with Melissa's formula above, if you need to know how many days elapsed when you do have a Date Completed filled in, you could add an if statement before that formula:

=IF(ISDATE([Date Completed]@row), NETDAYS([Date Received]@row, [Date Completed]@row), IF([Date Completed]@row="", NETDAYS([Date Received]@row, TODAY()), NETDAYS([Date Received]@row, [Date Completed]@row))

jgrotti · Accepted Answer

Thank you @Melissa Yamada and @Sandy Drew both formulas worked perfectly. Appreciate it!