Thread: IF function alternative

I'm trying to create a spreadsheet that lets you know the date a specific task needs to be redone.
The task must be completed every 3-5 years.

The beginning date is the date an object is manufactured.
Every 3-5 years these objects must be sent out to be recertified.

So, my current formula is this:

=IF(D224="","",IF(I224+$F$220>$I$5,I224+$F$220,IF(J224>$I$7,J224,IF(K224>$I$7,K224),IF(l224>$I$7,l22 4),IF(m224>$I$7,m224),IF(n224>$I$7,n224),IF(o224>$I$7,o224),IF(p224>$I$7,p224),IF(q224>$I$7,q224),IF (r224>$I$7,r224),IF(s224>$I$7,s224))))

But, since there are greater than 7 arguments I get the 'you've entered too many arguments' error.

The I-S cells in row 224 basically add either 3 or 5 years to the previous date.
$F$220 is the increment (either 3 years or 5 years)
$I$5 is the current date input as =Today()

so D224 is the date of manufacture, I224 is the D224 + either 3 years or 5 years depending on the item.
J224 - S224 are increments of either 3 or 5 years.

I'm sure there's a simple way to do this but I'm not an advanced Excel user by any means. I pretty much try to figure out what needs to be compared to what and do it step by step.

I'm wondering if there's a way to keep adding 3 or 5 years until the date is greater than the current date and then return that value.

The item is tagged as being a 3 year or 5 year item.
I found a way using the MIN function and searching the range for the minimum date greater than the current date.
It works now.

Thx.