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
Grateful of any help from you guys as always.
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
VBA Code:
=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.