Formula to automate Parent date

Evan Wilson

I can't seem to locate the formula that auto-fills a Parent date with the last date entered for a Child line item. 

 

It would be the same as the Start and End Date column parent cells, but those are system so I can't copy/paste the correct formula. 

 

EXAMPLE

Parent Date | =last date entered below

Child Date 1 | 1/3/17

Child Date 2 | 12/31/16

Child Date 3 | 1/7/17

 

I know it's probably simple but can't seem to find it and thought I would ask instead of spending another hour looking.

 

Thanks in advance.

Brett Evans

=MAX(CHILDREN())

 

If you put the formula above in the parent row of the date column you would get 1/7/17.  

=Min(CHILDREN())

Would return 12/31/16.

Mark Lappegaard

Thanks, Brett! Exactly what I needed!