Net Days Formula Help, Please!

Kristina Kazakoff

I need some help with these netdays formulas. I'm struggling with the best solution for excluding the blanks in the Date of Dis-enrollment column.

I have the netdays formula applied to the Length on Enrollment column with today as the end date. However, if there is a dis-enrollment date, then that dates needs to be the end date.

My thought was to create two columns for Length of Enrollment, active and inactive, but I keep getting #INPARSEABLE when attempting to ignore the blanks in Date of Dis-enrollment.

Or perhaps there is an alternate formula that will work for both scenarios?

Your input is greatly appreciated!

Paul Newcome

What about something like this...

=NETDAYS([Date of Enrollment]@row, IF(ISDATE([Date of Dis-enrollment]@row), [Date of Dis-enrollment]@row, TODAY()))

Paul Newcome

You just forgot to close out the ISDATE function. When you left the cell after writing the formula, Smartsheet automatically puts any missing closing parenthesis on the end of the formula, so now it reads as

ISDATE([End Date]@row, [End Date]@row, TODAY())

That is too many arguments for the ISDATE function.

If we take a closing parenthesis from the end and place it in the correct spot to close out that function, it should work for you.

=NETDAYS([Date of MIC Enrollment]@row, IF(ISDATE([End Date]@row), [End Date]@row, TODAY()))

Paul Newcome

What about something like this...

=NETDAYS([Date of Enrollment]@row, IF(ISDATE([Date of Dis-enrollment]@row), [Date of Dis-enrollment]@row, TODAY()))

Kristina Kazakoff

Oh, beautiful. Thanks again! Have a great weekend, Paul.

Paul Newcome

Happy to help! 👍️

Please don't forget to mark the most appropriate response as "helpful" so that others searching for a similar solution can know that one may be found here.

Kristina Kazakoff

I could use some assistance with this formula again...

I'm using it on a different sheet and I'm getting #INCORRECT ARGUMENT SET:

=NETDAYS([Date of MIC Enrollment]@row, IF(ISDATE([End Date]@row, [End Date]@row, TODAY())))

The columns are labeled a little differently on this sheet, but both sources are set as Date columns. I tried applying this formula this way too and got the same error message:

=NETDAYS([Date of MIC Enrollment]18, IF(ISDATE([End Date]18, [End Date]18, TODAY())))

Please and thank you!

Paul Newcome

You just forgot to close out the ISDATE function. When you left the cell after writing the formula, Smartsheet automatically puts any missing closing parenthesis on the end of the formula, so now it reads as

ISDATE([End Date]@row, [End Date]@row, TODAY())

That is too many arguments for the ISDATE function.

If we take a closing parenthesis from the end and place it in the correct spot to close out that function, it should work for you.

=NETDAYS([Date of MIC Enrollment]@row, IF(ISDATE([End Date]@row), [End Date]@row, TODAY()))

Kristina Kazakoff

Thank you 😁

Paul Newcome

Happy to help. 👍️