Hello -

So I have a data set that I'm pulling from a SQL table which populates a date with a time; the tiem and date are associated with a deadline.
I'm trying to write a formula that shows when a "case' is:
1. Past its deadline
2. Its deadline is today
3. Its deadline is tomorrow
4. Its deadline is the next day... and so on

The formula I'm using for the above 1. is =IF(Q201<TODAY(),"Yes","No") (Q201 is where the date and time are)
I then tried to use formula =IF(Q201=TODAY(), "Yes", "No") for 2.
and formula =IF(Q201=TODAY()+1, "Yes", "No") for 3. and so on.

The formula for 1. works no problem; the formulas for 2., 3., 4., so on do not show the correct response (i.e. "No" when it should be "Yes")

I think the issue is that in the Deadline date the time is autopopulated to 11:59 PM but it still doesnt make sense because thats still techinally today.

For example Q201 is 09/29/14 11:59 PM; so for 1. it states "No" as the case is not past todays date which is correct. For 2. it should be "Yes" as today is 09/29/2014 but is stating "No".

I'm thinking that when I put in the formula =TODAY() in the date and time format it brings up 09/29/2014 12:00 AM so something with the time is messing my formula up.
Any help is appreciated. Thanks!