Find the minimum and maximum dates for child rows

System

This discussion was created from comments split from: Find date formula.

Jake Gustafson

Hello, I'm trying to find the minimum and maximum dates for my child records, but only the MIN function is being accepted. I'm getting an error when using the MAX function. Also, I can't add the MIN to the next Parent to find the MIN from all its children that have additional children. Is there a better option to use for Dates?

Paul Newcome

What error are you getting?

What do you mean you can't add it to the next parent? I have hundreds of sheets that are set up like this, so it should be working for you.