Does this work for you:

=IF('04MQU'!D6,"Yes","NO")

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"bdq17" wrote in message
...
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.