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.

Rolf-42_0-1596281641711.png

=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