Put most recent date in a column header

Xavier Gomez

Hello, I need a little help with this one. I have an end date column where I would like the most recent date to appear in the column header. I'm not using a Gantt chart so I'm doing this manually.

The red arrow shows where I would like the most recent date to appear.

Thank you!

Paul Newcome

Do you have the other rows indented underneath the top row? If so, you can use

=MAX(CHILDREN())

Xavier Gomez

Thanks Paul.

Yes, the other rows are indented but the top row is restricted to a date format. When I place the formula in the cell and update the child rows, the column header is blank. Not sure what's going on there.

Paul Newcome

Are you able to provide a screenshot that includes the primary column so we can see the indentations in the sheet?