This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 45%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKP%3C/text%3E%3C/svg%3E)
Conditions 1-3 are variables that can change with the increase of subsequent data. If the following conditions are met, they hold true:
Condition 1, N2>=1
Condition 2, M2<1
Condition 3, if any day in L2: B2>=1 and AG2<1
After all three conditions are met, it shows that it was completed yesterday
Processes in Microsoft 365 for setting up Office apps, redeeming product keys, and activating licenses.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Hi,
Just checking in to see if the information was helpful. Please let us know if you would like further assistance.
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Answer accepted by question author
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 53%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
What is your question? Explain what the expression "if any day in L2" means.
IF(AND(N2>=1,M2<1,B2>=1,AG2<1),TODAY()-1,"NOT COMPLETE") but be aware that if you run this today and the conditions are met the result will be 30Dec23 and if you run it tomorrow the result will be 31Dec23.