Need to calculate number of days but only if there's an entry in both cells.

Chuckrugger

Hello,

I have a formula to calculate the number of days between two cells (Date Filed and Date Resolved) but can't figure out a way to keep the #InvalidDataType message from showing if the matter is still open and there's no entry for Date Resolved yet.

You can ignore column 10 in the image. That's just me messing around trying to figure out a solution.

Andrée Starå

Hi @Chuckrugger

I hope you're well and safe!

Try something like this.

=IFERROR(NETDAYS(Filed@row, [Date Resolved]@row), "")

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Chuckrugger

I hope you're well and safe!

Try something like this.

=IFERROR(NETDAYS(Filed@row, [Date Resolved]@row), "")

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Chuckrugger

That worked! Thanks very much.

Andrée Starå

@Chuckrugger

Excellent!

Happy to help!