Max child value dependent on max date

I have two columns a returned date and a recorded level.  The maximum recorded level is dependent on the maximum date.  The value will sit in the parent row.   Currently I have =MAX(CHILDREN()) in both columns.  Can this be done using Children or Parent references or is an IF statement required.  First time on the community so hope this is descriptive enough.