Today() not include current date

[Groovy Chick]

Hi, I have a formula that was kindly solved for me by someone on this forum. However, I have noticed that the >today() also returns a No for today's date but I only want a No if the date is greater than today. Is there a way to do this, please?

=IF(OR(C3="event",AA3>TODAY()),"N/A",IF(AA3>AC3,"Yes","No"))

 

[RoryA]

You will not get No if AA3 is greater than today's date. Does AA3 include a time portion as well as a date?

At a guess, you want AA3>=TODAY()

 

[Groovy Chick]

Hi, I only want to return a No if the date in AC is greater than the date in AA and not if it is equal to it which is what is currently happening. If the dates are equal I want it to return Yes. No, I don't have a time portion in the date field as well.

 

[RoryA]

Your current formula will return N/A if the date is greater than today, not No, which is why I asked.

 

[Groovy Chick]

The current formula I have works exactly as I need it to returning No if AC is greater than AA, Yes if AC is less than AA and N/A if AC blank or AB contains Event. It's just if the date in AC and AA are the same that I want to return a Yes but it is currently returning No.

 

[RoryA]

Then you want:

=IF(OR(C3="event",AA3>TODAY()),"N/A",IF(AA3>=AC3,"Yes","No"))

 

[Groovy Chick]

Works a treat. Thank you very much, RoryA

 

[RoryA]

Glad we could help.

 

[Joe4]

Note that in the future, you can simply continue on in the same (original) thread, as the question was about the original problem and formula I provided.
No need to start a new thread for a direct follow-up/continuation like that.