=IF(AND(M3<TODAY()-35,OR(W3="",X3="",Y3="",Z3="")),1,2)
--
Hth

Kassie Kasselman
Change xxx to hotmail


"Les" wrote:

I have the following formula:

=IF(AND(M3<TODAY()-35,W3="",X3="",Y3="",Z3=""),1,2)

Which basically says if the date entered in M3 is older than 35 days and W3,
X3, Y3, and Z3 have been not been populated then return a 1, otherwise return
a 2.

What I want it to say is if the date entered in M3 is older than 35 days and
the data is missing from just one of the cells W3, X3, Y3 or Z3, whichever
one it is, then return the values.

Thanks for helping.