Dates in a formula and blank cells in another

[SeanLCA]

hello
Need a formula that in Col C returns either 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.

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 Less than today's date, and in ColB has a date than in ColC = Clear

A1	B1	C1
12/13/19	12/12/2019	Clear
12/14/19	12/14/2019	Clear
12/15/19		Expired
12/16/19	11/16/2019	Clear
12/17/19	10/14/2019	Clear

 

[DanteAmor]

Hi, check the following.
It is not defined when today is equal to the date or when the date is greater than today and cell B has no date.

Book1
	A	B	C
1
2	13/12/2019	12/12/2019	Clear
3	14/12/2019		Expired
4	15/12/2019		undefined
5	16/12/2019		undefined
6	17/12/2019	14/10/2019	Clear
Hoja5

Cell Formulas
Range	Formula
C2:C6	C2	=IF(A2<TODAY(),IF(B2="","Expired","Clear"),IF(B2<>"","Clear","undefined"))

 

[SeanLCA]

worked... thanks

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.

 

[SeanLCA]

hello
I updated my condition ran into some issues.

I Need a formula that in Col C returns either 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 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

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

 

[DanteAmor]

Try this

=IF(A2<TODAY(),IF(B2="","Expired","Clear"),"Clear")