On Dec 31, 9:15*am, Diane1477
wrote:
I want to create a formula that returns an X in column A
if either of the following conditions are true:
1. If the date in column R is over 2 years from today's date, or
2. If there are notes in column S

I am using the formula :
=IF(OR(R2<TODAY()-730,S2<""),"X","")
But the above formula is returning an X in column A if column R is blank. *
In cases where column R is blank, column A should blank rather than
returning an X.

=if(R2="", "", if(or(R2<today()-730, S2<""), "X", ""))

Or:

=if(or(and(R2<"", R2<today()-730), S2<""), "X", "")