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!
Help Article Resources
Check out the Formula Handbook template!