Net Days Formula Help, Please!

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!

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!