Open Days in a project

nroberson31

I'm trying to calculate how many days a project stays open base on completion date:

This is the formula I'm using, the problem is counting an extra day if the project is completed.

=IFERROR(NETDAYS([Submission Date]@row, IF(ISBLANK([Completion Date]@row), TODAY(), [Completion Date]@row)), "No Submitted Date")

it was completed in 2 days, but the formula gave me 3 days.

Paul Newcome

Try this:

=IFERROR(NETDAYS([Submission Date]@row, IF(ISBLANK([Completion Date]@row), TODAY(), [Completion Date]@row - 1)), "No Submitted Date")

Paul Newcome

Try this:

=IFERROR(NETDAYS([Submission Date]@row, IF(ISBLANK([Completion Date]@row), TODAY(), [Completion Date]@row - 1)), "No Submitted Date")