Forum Discussion

Dazlin1027's avatar
Dazlin1027
Copper Contributor
Aug 01, 2020

Excel formula

What is the best formula for the following

 

column a is a program date

column b is Yes or No

column c is todays day

column d is days out

 

What formula will give me the following results in column d.  If Column c minus column a is < 0 and Column b is Yes or No then result is 0,  If column c minus column a is >0 And column b is No then show result of calculation

1 Reply

Sort By
  • Rolf-42's avatar
    Rolf-42
    Iron Contributor
    Aug 01, 2020

    Hello Dazlin1027

     

    You already have the logic in your text. It is only a matter of putting it together.

    =IF(C2-A2<0,0,(IF(AND(C2-A2>0,B2="no"),C2-A2,0)))

    You can even drop the column C and have today() instead in your formula like this =IF(TODAY()-A2<0,0,(IF(AND(TODAY()-A2>0,B2="no"),TODAY()-A2,0)))

    I hope it helps

    Cheers
    Rolf
    #MCT #LearnWithRolf #TheCloud42

     

Resources