The formula I'm using is =IF(COUNTA('04MQU'!D6)0,"Yes","No")

"bdq17" wrote:

i'm trying to write a formula that looks at a range of cells to see if a date
has been entered. if a date is there, then it should return "yes", if the
cell is blank it should return "no". How do i keep excel from ignoring the
blank cell? i tried countA but it didn't work.