My simple IF formula wont work!!

[R1chard]

In cells A1 and B1 i have two different dates. If A1 is 5 days or more less than B1 then i want C1 to display Yes, If A1 Is less than B1-5 then i want it to display no.

Simple formula - =IF(A1<(B1-5),"Yes","No")

But i want cell C1 to be blank if A1 is blank. I was using the formula below but it never worked!

=IF(A1=""," ",IF(A1<(B1-5),yES,IF(A1>(B1-5),No)))

 

[plettieri]

Hi:

Do you mean something like this

=IF(A1=""," ",IF(A1<(B1-5),"YES",IF(A1>(B1-5),"No")))

plettieri

 

[shades]

=IF(A1="","",IF(A1<(B1-5),"Yes","No"))

 

[Aladin Akyurek]

=IF(A1="","",IF(B1-A1>=5,"Yes","No"))

 

[R1chard]

Thats great, thanks alot