I have just checked that and mine and Ryan's both work in that circumstance.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Diane1477" wrote in message
...
I thought the formulas suggested worked, but in rows where column R fits
the
criteria for an X but Column S is blank, an X is not displaying in Column
A.
Any other ideas??

"Diane1477" wrote:

I am not sure how to create the following statement properly:

I have Dates in column R and comments in Column S. 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.

Any ideas how to get this to work correctly??? Please help...