Need help formula

[coach]

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.

[duane]

here is how I would do it

=IF(MONTH(MAX(A4:E4))<7,DATE(YEAR(MAX(A4:E4)),MONTH(MAX(A4:E4))+6,DAY(MAX(A4:E4))),DATE(YEAR(MAX(A4:E4))+1,MONTH(MAX(A4:E4)-6),DAY(MAX(A4:E4))))

if the assessments are in a4:e4