formula to take most current date from dates in 3 columns and add 6 months to the recent

Hi All,



So my problem is that I need a formula to take most current date from dates in three columns and add six months to the most recent date and put it in the fourth column.

For example:

(Date 1) - 29/05/19, (Date 2) - 24/10/18, (Date 3) - 18/07/18, (6 Month Date) - 29/11/19

If someone could please help me that would be great.

Current I have in the fourth column =EDATE(column,6). But it is a pain as I am having to manually change it to suit the most recent date of the three columns.


Regards

Doc

Or, =EDATE(MAX(A1:D1),6)