DATEDIF formula; Yes / No answer

Question

I am using the current formula:

=IF(DATEDIF(C1,D1,"d")>=3,"Yes","No")

If the date in D1

is 3 days or more after C1

, it gives the answer Yes

.

If the date is D1

less than 3 days after C1

, she gives and responds No

.

If C

1 is empty, it gives the answer Yes

. He has to say No

.

How do I get it to say No

without changing other answers?

+3

SteveB Apr 22. At 9:51 am

2 answers

AHC · Answer 1 · 2015-04-22T10:00:55+0000

you just need to insert another one if statement

between words like this:

=IF(ISBLANK(C1),"No",IF(DATEDIF(C1,D1,"d")>=3,"Yes","No"))

it should work now.

pnuts · Answer 2 · 2015-04-22T10:13:11+0000

Alternatively:

=IF(OR(C1="",D1<C1+3),"No","Yes")

Returns "No" if C1 is after D1.