nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

Find date formula

emmacomeau

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

Find more posts tagged with

Comments

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

Sign in to join the conversation!

Quick Links

Trending discussions

"Fields marked with an asterisk (*) are required." line on every form.
Hi, "Fields marked with an asterisk (*) are required." is the very first line in the body of every form I create. I don't remember seeing it before (unless you missed filling out a required field; then you would see the message). Is there a way to turn it off or change it? None of my forms are in English so the message is…
Best Way to Create a Stacked Bar Chart from multiple columns
I have a sheet that I pull into a report. The report I then want to use to make a stacked bar chart and put into a dashboard if I can. The columns I am trying to make into a stacked chart are: Lead, project and phase. The issue is that there are several leads and I need the stacked bar chart to show in different colors for…
Dynamic View Issue - Group Sharing
I have a dynamic view setup for a dashboard that has NO restrictions And on the Sharing tab, I have a Group that I created as the additional share access to the view But the individuals in the Group still cannot see the data from the dashboard. Am I missing something? Because when I share the view to them individually…