Find date formula

emmacomeau

Can anyone suggest a formula to return the earliest and latest date within a child column?

David Budnick

for the earliest date range you can use = MIN ([xx] 1 : [xxx] 19.

Where the XX is your starting position and XXX is you ending position, of course the row numbers will vary to what you need

I believe using the word LARGE instead of MIN will give the most recent date.

Hope this helps.

emmacomeau

That works for a range - thanks!

 

Any idea how to constrain the search just to a cell's children?

David Budnick

I'm glad the range worked. I'm not sure about a cell's children. Would it be possible to show me an example that's similar or if not too private part of the sheet you are working in?

Paul Newcome

=MIN(CHILDREN([Date Column Name]@row))

=MAX(CHILDREN([Date Column Name]@row))

If you are putting the formula in the same column as the children you are referencing, then you wouldn't even have to specify a cell.

=MIN(CHILDREN())

=MAX(CHILDREN())

emmacomeau

That worked, thanks!

Paul Newcome

Happy to help. 

nick cocilova

How to return the latest Children date only if all the Children are populated with dates?  I tried this, but did not work.

=IF(CHILDREN() <> "", MAX(CHILDREN(), ""))