Groovy Chick
Board Regular
- Joined
- Oct 10, 2017
- Messages
- 75
- Office Version
- 2016
- Platform
- Windows
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"))