Formula Help - if cell = X then show network days

jacquedale

I hope my explanation makes sense.

I currently have a basic formula that shows "networkdays" between 2 dates, however it obviously shows "invalid date type" when the "end date" has not been entered

=NETWORKDAYS([Date Open]@row, [Actual Closure Date]@row)

. So we want the cell to show "duration to close" when status is "closed" and there are start/end dates. But when status is "open" we want it to show how many days it has been open.

I tried to do it in separate columns (for ease) since I was struggling, but I can't get anything to work. As a separate column for "days open I have

=IF(CONTAINS("Open", [Issue Status]@row, NETWORKDAYS([Date Open]@row, TODAY())))

Of course if there is a way to combine the two in one formula that would be great.

Thanks in advance for any help.

Laurie Olson

Give this a try:

=IF([Date Closed]@row <> "", NETWORKDAY([Date Open]@row, [Date Closed]@row), NETWORKDAY([Date Open]@row, TODAY(0)))

Laurie Olson

Give this a try:

=IF([Date Closed]@row <> "", NETWORKDAY([Date Open]@row, [Date Closed]@row), NETWORKDAY([Date Open]@row, TODAY(0)))

jacquedale

@Laurie Olson you are a life-saver that worked perfectly!! Thank you so much.

Laurie Olson

You're welcome, Jacque!