Formula

[Cindy]

I need column U to flag me if the date is column P is
greater than or equal to today's date AND if column R is
empty. Can anyone help me with that formula?

 

[Frank Kabel]

Hi Cindy
try
=IF(AND(R1="",P1>=TODAY()),"FLAG","")

 

[Guest]

THANKS!! It worked!

-----Original Message-----
Hi Cindy
try
=IF(AND(R1="",P1>=TODAY()),"FLAG","")

--
Regards
Frank Kabel
Frankfurt, Germany


.