Parent Row formula for Max date + 540 days
I'm trying to use a formula in the Parent row of several date columns that will:
1) give me the MAX date from the child (anywhere from 1-12 rows)
2) add 540 days to that date (from #1)
This will work using: =MAX(CHILDREN()) + 540
Except if the child row is blank and then I get the error message #DATE EXPECTED
I've attached a screenshot. Any assistance would be greatly appreciated.