If Date is blank + past formula

dhawkins

I can't figure out why this would return a "yes" when the date cell is blank.

=IF([Date of Site Survey (Product)]@row = " ", " ", IF(TODAY() > [Date of Site Survey (Product)]@row, "yes", " "))

Intended logic/result -

If date cell is blank, then "blank" (this worked when I tried without the 2nd argument added)

If date is in the past, the "yes" - if not "no"

Please advise...thanks!

Paul Newcome

Try this:

=IF([Date of Site Survey (Product)]@row <> "", IF(TODAY() > [Date of Site Survey (Product)]@row, "yes", "no"))

Paul Newcome

Try this:

=IF([Date of Site Survey (Product)]@row <> "", IF(TODAY() > [Date of Site Survey (Product)]@row, "yes", "no"))

dhawkins

Thanks Paul! Can you point out how the <> worked vs my approach? How does that "read"?

Paul Newcome

<> ""

means "is not blank". So the way my formula reads is

IF the date is not blank then evaluate for IF TODAY is greater than the date...

Will Bastin

Hi Paul. I used your formula above and it works really great on my sheet.

Currently I have this: =IF(Publication@row <> "", IF(TODAY() > Publication@row, "yes", "no"))

What I want to do is also only mark whether my publication is "Yes" when the column "Publication Complete" =0 (not checked). Do you know what I would need to include here? I have tried AND arguments but have returned UNPARSABLE.

Thanks in advance.

Paul Newcome

@Will Bastin Try this:

=IF(Publication@row <> "", IF(OR(TODAY()>Publication@row, [Publication Complete]@row <> 1), "yes", "no"))

Will Bastin

@Paul Newcome Thanks so much. It worked great, I just use AND instead.

=IF(Publication@row <> "", IF(AND(TODAY()>Publication@row, [Publication Complete]@row <> 1), "yes", "no"))

Thanks for your help.