I have two formulas that both work independently but I want to merge them together and every time I try I get the message that I have too many arguments, can someone help? I have included what I am trying to do and the two formulas.
I have three date columns. The first date column contains the date an item is received. The second date column contains the date an action is completed and the third date column contains the date the action was supposed to be completed. I have a fourth column that tells you if the item was past due or not. The column that tells the user when the item was supposed to be completed uses a formula to calculate the due date. The past due column using a formula that currently looks at the item received date and the action completed date and populates with a 'Yes' or 'No' if the item was past due when it was completed. This is the formula:
=IF(ISBLANK(J6),"",IF(ISBLANK(N6),"",IF(NETWORKDAYS(J6,N6,Holidays!$B$2:$B$12)>10,"Yes","No")))
What I WANT the Past Due column to do is be a little predictive. I want it to tell you if the item was done late (which it currently does via the formula above) but I also want it to tell the user that the item is past due if there is no date entered in the action completed column AND today's date is greater than the date the action was supposed to be completed. The formula below will accomplish the second part of the task but I cannot figure out how to put the formulas together so that the Past Due column will tell a user the item was done late OR that it is late because it's past the due date and there is no date completed date entered.
=IF(AND(ISBLANK(N8), TODAY() > O8), "Yes", "No")
Bookmarks