# Help with a NETDAYS formula

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:

And a screenshot of the sheet:

Tags:

• 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!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!