True false statement with dates

[hrclark]

Probably a novice issue, but I cannot figure out how to do a true/false if/then statement.

I want a formula that for cell C3 says if cell H3 (in a different worksheet) has a date in it, then display Yes, if there is nothing in it, display No.

I have tried =IF('Participant Overview'!H3, "Yes", "No") thinking a logical argument would work that if there was something in the cell it would equal true and false would be nothing in the cell. However, I get No displayed no matter what is in the H3 cell.

Thanks!

[hrclark]

I have now tried this to no avail:

=(DATE('Participant Overview'!H3), "Yes"), (ISBLANK('Participant Overview'!H3),"No")

Any ideas?

[martindwilson]

if you are not having anything else in those cells other than dates you can test with =isnumber()
IF(isnumber('Participant Overview'!H3), "Yes", "No")
to cater for zeros you could use
IF(and(isnumber('Participant Overview'!H3),'Participant Overview'!H3>0), "Yes", "No")

[hrclark]

That worked! Thanks so much!