How to display a MIN date on parent row when all children date rows contain a formula
I have a date column (Start Date) which is being populated from a Vlookup which references a separate calendar table. For the Parent Rows of the populated date column (Start Date), I would like to display the minimum date of its children.
Formula used in the Parent cell: =MIN(children())
Result: no error is thrown, but no information is populated
Assumption: The MIN formula does not work when used with Children cells that are populated with a formula.
This sheet must be automated as the dates change frequently, so I can't copy/paste the dates into another column to then do the MIN calculation there.
Does anyone know a way to auto populate the Parent Dates in this scenario? Thanks in advance for your help!!
Help Article Resources
Check out the Formula Handbook template!