Forum Discussion
Solved
If today's date is greater than a certain date by a number of days
Hi All Good morning I want an equation that shows a note if today's date is four days greater than the date in field A6 A6=16/06/2023 Today date = 20/06/2023
In another cell:
=IF(A6=TODAY()-4, "The date in A6 is four days ago!", "")
or perhaps
=IF(AND(A6<>"", A6<=TODAY()-4), "The date in A6 is four or more days ago", "")
In another cell:
=IF(A6=TODAY()-4, "The date in A6 is four days ago!", "")
or perhaps
=IF(AND(A6<>"", A6<=TODAY()-4), "The date in A6 is four or more days ago", "")
Thank you it's working