Descendant date formula

James Tucker

is there a way to return the oldest/newest date of the descendant dates.

for example, if the parent cell is the name of the project I want the start of the project to match the earliest date found in all of the sub task dates, and the end date of the project to match the last date found in all of the sub tasks

Thanks for the help

Paul Newcome

Yes. You would use a MIN or MAX function.

=MIN(DESCENDANTS())

=MAX(DESCENDANTS())