Help with a NETDAYS formula

brunocasey7

I have a formula in my sheet that is counting the days of an assignment since it was assigned. I would like it to stop counting once the row is marked complete or a date of completion is added. For example, in the screenshot below, the 37 in row 4 should be a 36 since the "Date Completed" column is filled in and/or the "Completed" column is checked.

This is the formula I am currently using:

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

And a screenshot of the sheet:

Rochelle from Agilize

Hi Bruno,

You're formula needs to account for the Date Completed column so it "stops" the count. You'll want to use something like this:

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

Essentially, if there is a date in Date Completed, then calculate the net days between that date and today. If not, then calculate the net days between Date Assigned and Today.

Hope this helps!