Open Days in a project
Options
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.
Best Answer
-
Try this:
=IFERROR(NETDAYS([Submission Date]@row, IF(ISBLANK([Completion Date]@row), TODAY(), [Completion Date]@row - 1)), "No Submitted Date")
Answers
-
Try this:
=IFERROR(NETDAYS([Submission Date]@row, IF(ISBLANK([Completion Date]@row), TODAY(), [Completion Date]@row - 1)), "No Submitted Date")
