And I copied and pasted the cell reference from your post to my post, so I
would guess that something is wrong with your sheet name!

If D6 contained Text, you would have returned a #Value! error.

Start by typing
=IF(
into a cell on the same sheet you used for my formula,
then navigate to the sheet containing the dates,
and click in D6,
and then click in the formula bar, and enter this after the D6
,"YES","NO)
and then hit <Enter

What do you get returned?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"bdq17" wrote in message
...
I cut and pasted your formula into the spreadsheet and I get a ref # error

"RagDyer" wrote:

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.