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

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!