Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

DATEDIF formula; Yes/No answer

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?

like image 831
SteveB Avatar asked Jan 31 '26 01:01

SteveB


1 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.

like image 135
Marcel Avatar answered Feb 01 '26 19:02

Marcel



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!