How to I combine two IF(AND formulas to get desired results

[ArcticAce]

Sorry, I am sleepy: How do I combine two IF(AND formulas to get a desired result or leave blank if both formulas are FALSE


The formula in B1 is =IF(AND($A1>=$E$1,$A1>=$F1),$F$2,"")

The formula in C1 is =IF(AND($B1>=$E$2,$B1>=$F2),$F$3,"")

I need a formula that can be combined with the formula in C1 to give me the result of C12, if C1 is FALSE, but leave blank any dates in Column A that are after 1/1/2018 and so on.

Can anyone help me with this issue, and I have tried my best to explain it.​

	A	B	C	D	E	F
1	10/1/2017​ <strike></strike>	<strike></strike>11/30/2017	12/31/2017		10/1/2017	10/31/2017
2	11/2/2017		FALSE		11/1/2017	11/30/2017
3	12/13/2017		FALSE		12/1/2017	12/31/2017
4	1/6/2018		FALSE		1/1/2018	1/31/2017
11	10/1/2017​ <strike></strike>	11/30/2017​	12/31/2017​ <strike></strike>	<strike></strike>
12	11/2/2017​ <strike></strike>	<strike></strike>	12/31/2017
13	12/13/2017​ <strike style="background-color: transparent; border-collapse: collapse; color: rgb(34, 34, 34); font-family: Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: line-through; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; width: auto; word-spacing: 0px;"></strike><strike></strike>	<strike></strike>
14	1/6/2018​ <strike></strike>	<strike></strike>
		<strike></strike>

<tbody>
</tbody>

 

[oldbrewer]

but leave blank any dates in Column A that are after 1/1/2018 and so on.

how are col A cells checked

The formula in C1 is =if(iserror(IF(AND($B1>=$E$2,$B1>=$F2),$F$3,"")),dothis,dothat))

check how many brackets you need

 

[ArcticAce]

Can you give me more details about the portions you want me to try?

 

[oldbrewer]

I need a formula that can be combined with the formula in C1 to give me the result of C12, if C1 is FALSE, but leave blank any dates in Column A that are after 1/1/2018 and so on.

I do not understand what you mean above eg leave blank any dates - how are you changing cells in column A ?

 

[ArcticAce]

I need a formula that can be combined with the formula in C1 to give me the result of C12, if C1 is FALSE, but leave blank any dates in Column A that are after 1/1/2018 and so on.

I do not understand what you mean above eg leave blank any dates - how are you changing cells in column A ?

The dates in column a are entered when a discussion with an employee is conducted. The other columns are for automation to show when the next discussion is due. So the columns after A will show all discussions for the year