Trying to compare two dates and print the most recent plus seven years

[Phily50]

I'm getting myself in all sorts of a muddle with this formula.

I have two dates - one in cell D8 and one in cell E8. I want to find the most recent date and then add seven years to it which will then put that new date into cell J8. The reason I have used the isblank and iserror is because there is blanks (obvs!) and also some cells contain n/k for not known.

I have adapted this formula from one that was working before that only looked at one date - it was working - but now I have added E8 it has to compare the two rather than just look at one.

I dont really want it to show 01/01/1900 if one of the cells is blank or says n/k

=IF(ISBLANK(DATE(YEAR(MAX(E8,D8))+ 7)), MONTH(MAX(E8,D8), DAY(MAX(E8,D8))),"",IFERROR(DATE(YEAR(MAX(E8,D8D8)))) + 7, MONTH(MAX(E8,D8(D8), DAY(MAX(E8,D8(D8)),""))))

Grateful of any help from you guys as always.

 

[Phily50]

=IF(and(e8=0,d8=0),"",EDATE(MAX(D8:E8),7*12),""))

"You've entered too many arguments for this function"

 

[awoohaw]

Book4
	D	E	F
7	Date1	Date2	Max + 7
8	5/13/2022	dkajlkd	5/13/2029
9	5/18/2021	3/6/2020	5/18/2028
10	12/18/2022		12/18/2029
11	n/k	5/19/2020	5/19/2027
12	DKFJ	NK
13	12/6/2022	5/25/2020	12/6/2029
14
15	12/6/2022	5/25/2020	12/6/2029
Sheet1

Cell Formulas
Range	Formula
F8:F15	F8	=IF(AND(ISNUMBER(D8)=FALSE,ISNUMBER(E8)=FALSE),"",EDATE(MAX(D8:E8),7*12))

 

[awoohaw]

"You've entered too many arguments for this function"

I fixed it, and submitted a new mini workbook.

 

[Phily50]

Thanks for that.
How about

=LET(m,MAX(D8:E8),IF(m=0,"",EDATE(m,7*12)))

This works perfectly. I have never heard of the LET function before. thankyou.

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Phily50]

Book4
	D	E	F
7	Date1	Date2	Max + 7
8	5/13/2022	dkajlkd	5/13/2029
9	5/18/2021	3/6/2020	5/18/2028
10	12/18/2022		12/18/2029
11	n/k	5/19/2020	5/19/2027
12	DKFJ	NK
13	12/6/2022	5/25/2020	12/6/2029
14
15	12/6/2022	5/25/2020	12/6/2029
Sheet1

Cell Formulas
Range	Formula
F8:F15	F8	=IF(AND(ISNUMBER(D8)=FALSE,ISNUMBER(E8)=FALSE),"",EDATE(MAX(D8:E8),7*12))

This also works And I understand why which is a bonus! Thankyou all for your help!

 

[awoohaw]

I think LET is only available in 365 versions. Older versions are not compatible with it.