dmxcasper2
Board Regular
- Joined
- Mar 21, 2012
- Messages
- 65
Problem Statement:
I am having difficulty creating a formula that will take multiple AND and IF criteria into calculation based on today's date. Please see below for (4) logic statements that I have been trying to incorporate into a single formula string.
Column E is the output. (Where the formula would reside)
Formula is needed based on the following logic statements:
Any help is appreciate it.
I can't find a good source online to explain/teach the logic behind creating these AND and IF combinations.
I am having difficulty creating a formula that will take multiple AND and IF criteria into calculation based on today's date. Please see below for (4) logic statements that I have been trying to incorporate into a single formula string.
Column E is the output. (Where the formula would reside)
![Capture.jpg](/board/proxy.php?image=https%3A%2F%2Fi.postimg.cc%2F5ytKQDPP%2FCapture.jpg&hash=bfb11dd3da9106d4ad78f5c4c3545c16)
Formula is needed based on the following logic statements:
- If there is no date in Column A, then default to "blank" in Column E
- If there is a non-date attribute (example: "TBD", or "TBA") in Column A, then default to "blank" in column E
- If there is a date in Column B, then subtract it from MAX of Column C and D.
- If there is a date in Column A and Column B is blank, take the MAX date of Column C and D and subtract it from today's date
Any help is appreciate it.
I can't find a good source online to explain/teach the logic behind creating these AND and IF combinations.