Count Children formula
I have this formula that is working properly except I need to adjust it. Basically what this formula is doing is counting the children rows if a specific date column has nothing (is blank). However, what I need to also adjust for is to have my formula return a "zero (0)" if the units have expired (captured in a helper symbol column with a formula that raises the flag if the units are expired). What else do I need to add to make this formula work properly? I am stumped, any help would be greatly appreciated, thank you.
My formula currently is this ...
=COUNTIFS(CHILDREN([Stipend Requested]@row, NOT(ISDATE(@cell)))