If and statement not working

[samyscraps01]

A (Original Hire)	B (Re-Hire)	C =IF(A=B, TRUE)	D TERM DATE	E 1 yr of return	F =IF(AND(C1=FALSE,$B1>$D1,$B1<$E1),"Include in Ceremony","Do not Include")
12/8/10	09/25/18	FALSE	2/22/18	2/22/19	Include in ceremony
01/16/17	01/16/17	TRUE

<tbody>
</tbody>

Hi, this is a copy of the formula that i'm working on.

=IF(AND(C1=FALSE,$B1>$D1,$B1<$E1),"Include in Ceremony","Do not Include")

The only difference is I want to add one small thing, I want it to include if B1=TRUE, then say "include” without needing to perform any other operations like it does for False. I can't seem to get it to work properly.

 

[JoeMo]

Try:

=IF(C1=TRUE,"include",IF(AND($B1>$D1,$B1<$E1),"Include in Ceremony","Do not Include"))

EDIT: I'm assuming you meant if C1 = TRUE, not B1.

 

[samyscraps01]

@JoeMo, yes you are correct. I mean C=1. It works now! You are a genius!!!! THANK YOU.