hello
I updated my condition ran into some issues.
I Need a formula that in Col C returns Clear if in ColA there is a Date and in ColB is a Date. ColC is Expires if ColA there is a Date that is Less Than Today and ColB is Blank. Sample Below.
Updated Condition:
If there is a Date in Col A that is Less than today's date, and in ColB is blank than in ColC I=Expired
If there is a Date in Col A that is Greater than or equal today's date, and in ColB is blank than in ColC =Clear
If there is a Date in Col A that is Less than today's date, and in ColB has a date than in ColC = Clear
If there is a Date in Col A that is today's date or Greater and in ColB has a date than in ColC = Clear
If there Blank in Col A and in ColB has a date than in ColC = Clear
Sample:
I updated my condition ran into some issues.
I Need a formula that in Col C returns Clear if in ColA there is a Date and in ColB is a Date. ColC is Expires if ColA there is a Date that is Less Than Today and ColB is Blank. Sample Below.
Updated Condition:
If there is a Date in Col A that is Less than today's date, and in ColB is blank than in ColC I=Expired
If there is a Date in Col A that is Greater than or equal today's date, and in ColB is blank than in ColC =Clear
If there is a Date in Col A that is Less than today's date, and in ColB has a date than in ColC = Clear
If there is a Date in Col A that is today's date or Greater and in ColB has a date than in ColC = Clear
If there Blank in Col A and in ColB has a date than in ColC = Clear
Sample:
A1 | B1 | C1 |
12/13/19 | 12/12/2019 | Clear |
12/14/19 | 12/14/2019 | Clear |
12/16/19 | 11/13/2019 | Clear |
12/15/19 | Expired | |
12/17/19 | 10/14/2019 | Clear |
Last edited by a moderator: