I have a spread sheet that is used to show dates that an employee has been assessed in his/her job.

The sheet has 5 columns showing dates of assessment. The sixth column shows the date 6 months from the last assessment date. Is it possible to have a formula that updates the sixth column on adding new updated assessment date.