Find date formula

emmacomeau · 02/22/19

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

David Budnick · 02/22/19

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 · 02/22/19

That works for a range - thanks!

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

David Budnick · 02/25/19

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 · 02/25/19

=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 · 02/26/19

That worked, thanks!

Paul Newcome · 02/27/19

Happy to help.

nick cocilova · 05/13/19

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(), ""))

Find date formula

Comments

Categories