IF or IF AND Formula conditions DATE
Dear, I appreciate your help.
I need to create a formula that changes the status column depending on the following conditions. (The image in the example table has reference TODAY = August 28, 2019)
1) If the Balance column is equal to 0 (Green)
2) If the Balance column is less than 0 (Yellow)
3) If the Balance column is greater than 0 and the Expiration Date column is greater than TODAY (Red)
Help Article Resources
Check out the Formula Handbook template!