Excel formula

Copper Contributor

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

Hello @Dazlin1027


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



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

#MCT #LearnWithRolf #TheCloud42