Groovy Chick
Board Regular
- Joined
- Oct 10, 2017
- Messages
- 75
- Office Version
- 2016
- Platform
- Windows
Hi, I have dates in cells AA3 and AC3. What I want to do is return Yes if the date in cell AA3 is greater than the date in cell AC3 but only if the date in cell AA3 is less than today. If the date in cell AA3 is greater than today I want to ignore it, so probably return an N/A. If cell AC3 is blank and AA3 is less than today then I still want to return a yes but if cell AC3 is blank and AA3 is greater than today I would want to ignore it, so probably return an N/A. For anything else I would like to return No. Can anyone help? I am going around in circles! Many thanks.