I use 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 an answer of Yes.
If the date in D1 is less than 3 days after C1 it gives and answer of No.
If C1 is blank it gives an answer of Yes. It needs to say No.
How do I get it to say No without changing the other answers?
you just need to insert another if statementin between like this:
=IF(ISBLANK(C1),"No",IF(DATEDIF(C1,D1,"d")>=3,"Yes","No"))
it should work now.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With