Combine IF THEN Function with ISNUMBER SEARCH?

Hi everyone,

I'm having trouble coming up with a formula to evaluate this two part statement:

If A3 contains the words "apple" or "orange", then E3=[Today()-(D3+365)];
if A3 does not contain "apple" or "orange", then E3={Today()-[D3-(3*365)]}


What I have so far is: E3=IF({Isnumber{search[("apple","orange"),A3]}},[Today()-(D3+365)],{Today()-[D3+(3*365)]})

A3 is independent of the formula, and will contain a number that may or may not be denoted by the words "apple" or "orange'.
D3 is a date that will be changed occasionally.

Do you have an idea of how to approach this?

maybe:
=IF(SUM(--ISNUMBER(SEARCH({"apple","orange"},A3,1))),TODAY()-D3+365,TODAY()-D3-3*365)

E3:

Please Login or Register  to view this content.

maybe this one

=IF(OR(A3={"Apple","Orange"}),TODAY()-(D3+365),TODAY()-(D3-(3*365)))

Try:
=TODAY()-D3+IF(AND(A3<>"apple",A3<>"orange"),3*365,-365)