Looking for the simplest formula to pull in the max value for the date of child rows

acunningham95401

We have parent-child rows for reports, I would like the parent row to have a formula that pulls the most recent date in the child rows into the date column to keep the parent in the correct order on the sheet.

TIA

David Tutwiler

I think you can do that by putting this formula in the parent cell for dates:

=MAX(CHILDREN())

acunningham95401

Thank you! I used that - it didnt work and I thought I was doing something wrong....but it worked now.

David Tutwiler

That's weird, but ultimately I'm glad it's working now.