Forum Discussion
Dazlin1027
Jul 31, 2020Copper Contributor
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 c...
Rolf-42
Aug 01, 2020Iron Contributor
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