Date Formula

Susan van Niekerk

Hi Brain Trust

I have a sheet with Parent row - with a sub Phase row and then the children - example below

I need the

Light Grey Cells to reflect the earliest date of the children underneath it

The Dark Grey Cells to reflect the earliest date of the light grey cells - there are several of these sub phases

Light Blue Cell to reflect the earliest date of all the dark grey cells(phases)

Is this do able??

Matt Johnson

Hi @Susan van Niekerk

For the earliest date formula with children you can use =MIN(CHILDREN()). For the latest use MAX.

In my experience when this is needed, I try to make it so no information is manually inputted into the parent rows. That way the parent rows can be locked. Otherwise users tend to not realize there's a formula there and input values over it.

I hope that helps.

Matt