Comparing two dates with a twist

[userpoets]

Good afternoon!

We are trying to automatically show when two separate dates are greater than three days apart, or when there is not a second date with which to compare.

Example:

The first set of dates is GOOD because they are less than three days apart.
The third set of dates is BAD because they are more than three days apart.

The second set of dates is BAD but we are trying to get that to show a blank since there is no first date listed.

Our current formula reads like this:

=IF(($AB9-$AA9)>3,"BAD","GOOD!")

I've been experimenting with the "IFERROR" syntax but I'm not able to get it worked out. Any assistance is appreciated!

 

[Joe4]

Try this:

=IF(OR($AA9="",$AB9="",$AB9-$AA9>3),"BAD","GOOD")

 

[userpoets]

It didn't work, it gave me the same results I was getting with my original formula. It feels like an "IFERROR" should work but since the blank cells aren't causing an error, it gets weird. Thanks for the quick reply, though!

 

[Joe4]

The formula works for me, as shown below:

Are the blank cells really blank, or is there a space or something else in there?
What does this formula return:

=LEN(AA10)

If it returns anything other than 0, your cell is not actually blank/empty.

Also, are your entries entered as valid dates or text?
What does this formula return?

=ISNUMBER(AA9)

If it returns FALSE, your entry is Text and not not a valid Date entry.