Last date entered in a subtable

I have a list of inspection dates in a subtable. I would like to be able to populate a field with the last inspection date entered into the subtable to enable a future date to be calculated from this field.
Any help would be appreciated.

Hi, please try MAX() formula to get the last date in subtable.

Works like a charm, many thanks.