Excel 2007 : =IF formula to identify "Yes" or "No" if between two dates

**Rizzu** · 07-08-2011, 01:59 PM

Good afternoon everyone, i'm a little stumped on a formula that I don't believe i should be having much issues with, and thought i'd ask around. The issue i'm having right now is i'm trying to compare 3 cells together to give me a "Yes" or "No" answer, here's what i'm trying to do

Please refer to attachment.

I'm trying to use a formula in D2 that looks to see if C2 falls in between the time and date for A2 and B2 that basically asks "Is this on time?"

I want a formula that basically does both of these simultaneously:
=IF(C2>A2,"Yes","No")
=IF(C2<B2,"Yes","No")

Any help is appreciated , thank you!

**tigertiger** · 07-08-2011, 02:04 PM

Originally Posted by Rizzu

I want a formula that basically does both of these simultaneously:
=IF(C2>A2,"Yes","No")
=IF(C2<B2,"Yes","No")
Any help is appreciated , thank you!

try

=IF(AND(C2>A2,C2<B2),"Yes","No")

or (depend on your need)

=IF(OR(C2>A2,C2<B2),"Yes","No")

**Ron Coderre** · 07-08-2011, 02:06 PM

Using your posted workbook, this regular formula returns Yes
if the Delivery value is between the Early and Late values, inclusive:

Please Login or Register  to view this content.

Is that something you can work with?

**Rizzu** · 07-08-2011, 02:37 PM

Originally Posted by tigertiger

try

=IF(AND(C2>A2,C2<B2),"Yes","No")

or (depend on your need)

=IF(OR(C2>A2,C2<B2),"Yes","No")

Aha! This one did the trick, i made one adjustment to your "and" formula and it did exactly what i needed it to (i didn't know (and( existed!)

=IF(AND(C2>=A2,C2<=B2),"Yes","No")

Thank you very much.

Ron sadly median didn't do what i need it to

, what i needed to do was make it identify if the Delivery Time fell between the Early Appointment and Late Appointment time to flag if it was late or not, so tiger's did exactly what i needed. Thank you both for your assistance