Forum Discussion
Solved
Assistance with Date Formula
Hi there, After spending the last 45 minutes researching and trying to troubleshoot this myself, I have given up and am now seeking support. I am trying to create the following statement (w...
Yes, that is a different situation. An empty cell is treated as "less than" any date. So:
=IF(AND(D2<>"", D2<=TODAY()), "YES", "")
Yes, that is a different situation. An empty cell is treated as "less than" any date. So:
=IF(AND(D2<>"", D2<=TODAY()), "YES", "")
Thank you so much, that did the trick!