IF between dates

[pook_666]

Hi magicians!

I'm trying to write an IF statement between dates.

I have a date in one column and if the date falls before, after or between a set of two dates I want an IF statement (or something that works!) to put a value in another cell.

Might be better if I gave you an example of what I'm trying to accomplish....see below where I want in cell D2 either P (date falls before start date in A2), F (date falls after end date in B2) or C (if date falls within these two dates of A2 and B2)

Hopefully I'm being clear enough for someone to help, if not will happily give additional information!

Thanks,

 

[bstory84]

You were on the right track.
try this
just made a minor change

=IF(C2<A2,"P",IF(C2>B2,"F",IF(AND(C2>A2,C2<B2),"C")))

1 call out. You may want to account for dates Equal to.

 

[Eric W]

By taking advantage of the order that the IFs are evaluated, you can shorten that a bit:

Book1
	A	B	C	D
1	Start Date	End Date	Current Date	C/P/F
2	12/1/2021	12/13/2021	12/23/2021	F
Sheet26

Cell Formulas
Range	Formula
D2	D2	=IF(C2<A2,"P",IF(C2<B2,"C","F"))

And as bstory84 said, you can use < or <= as the operators to account for equals.

 

[Fluff]

No need for the final if, you can do it like

=IF(C2<A2,"P",IF(C2>B2,"F","C"))

 

[pook_666]

Awesome - thank you all for helping!

 

[Fluff]

Glad we could help & thanks for the feedback.