Explanation of this problem: Column N has dates in the form of Year, Month, because I am comparing that to an Initial Inspection Date in Column C1 through various number of C columns . N1 is the date after a month has past since the Initial Inspection Date and N2 is the after 6 month has past the Initial Inspection date. There is also Column O1 which say “New” and that is being compared to Column D1 through a various number of D Columns. In Column K, titled Notes, after the comparison is done, a status noted base on the Column N, Column C and Column D. My problem is that after 6 month, the Labwork status in column D if not change to close is “Past Due” and I need a way using this equation to note that in Column K. Below is the rest of the details for this problem. Since I can only use 3 argument for an IF statement, how can I add on to the equation to get it to provide the “Past Due Move to Close” status in Column K?

Explanation of this problem: Column N has dates in the form of Year, Month, because I am comparing that to an Initial Inspection Date in Column C1 through various number of C columns . N1 is the date after a month has past since the Initial Inspection Date and N2 is the after 6 month has past the Initial Inspection date. There is also Column O1 which say “New” and that is being compared to Column D1 through a various number of D Columns. In Column K, titled Notes, after the comparison is done, a status noted base on the Column N, Column C and Column D. My problem is that after 6 month, the Labwork status in column D if not change to close is “Past Due” and I need a way using this equation to note that in Column K. Below is the rest of the details for this problem. Since I can only use 3 argument for an IF statement, how can I add on to the equation to get it to provide the “Past Due Move to Close” status in Column K?

Explanation of this problem: Column N has dates in the form of Year, Month, because I am comparing that to an Initial Inspection Date in Column C1 through various number of C columns . N1 is the date after a month has past since the Initial Inspection Date and N2 is the after 6 month has past the Initial Inspection date. There is also Column O1 which say “New” and that is being compared to Column D1 through a various number of D Columns. In Column K, titled Notes, after the comparison is done, a status noted base on the Column N, Column C and Column D. My problem is that after 6 month, the Labwork status in column D if not change to close is “Past Due” and I need a way using this equation to note that in Column K. Below is the rest of the details for this problem. Since I can only use 3 argument for an IF statement, how can I add on to the equation to get it to provide the “Past Due Move to Close” status in Column K?

Explanation of this problem: Column N has dates in the form of Year, Month, because I am comparing that to an Initial Inspection Date in Column C1 through various number of C columns . N1 is the date after a month has past since the Initial Inspection Date and N2 is the after 6 month has past the Initial Inspection date. There is also Column O1 which say “New” and that is being compared to Column D1 through a various number of D Columns. In Column K, titled Notes, after the comparison is done, a status noted base on the Column N, Column C and Column D. My problem is that after 6 month, the Labwork status in column D if not change to close is “Past Due” and I need a way using this equation to note that in Column K. Below is the rest of the details for this problem. Since I can only use 3 argument for an IF statement, how can I add on to the equation to get it to provide the “Past Due Move to Close” status in Column K?

Explanation of this problem: Column N has dates in the form of Year, Month, because I am comparing that to an Initial Inspection Date in Column C1 through various number of C columns . N1 is the date after a month has past since the Initial Inspection Date and N2 is the after 6 month has past the Initial Inspection date. There is also Column O1 which say “New” and that is being compared to Column D1 through a various number of D Columns. In Column K, titled Notes, after the comparison is done, a status noted base on the Column N, Column C and Column D. My problem is that after 6 month, the Labwork status in column D if not change to close is “Past Due” and I need a way using this equation to note that in Column K. Below is the rest of the details for this problem. Since I can only use 3 argument for an IF statement, how can I add on to the equation to get it to provide the “Past Due Move to Close” status in Column K?

Explanation of this problem: Column N has dates in the form of Year, Month, because I am comparing that to an Initial Inspection Date in Column C1 through various number of C columns . N1 is the date after a month has past since the Initial Inspection Date and N2 is the after 6 month has past the Initial Inspection date. There is also Column O1 which say “New” and that is being compared to Column D1 through a various number of D Columns. In Column K, titled Notes, after the comparison is done, a status noted base on the Column N, Column C and Column D. My problem is that after 6 month, the Labwork status in column D if not change to close is “Past Due” and I need a way using this equation to note that in Column K. Below is the rest of the details for this problem. Since I can only use 3 argument for an IF statement, how can I add on to the equation to get it to provide the “Past Due Move to Close” status in Column K?

Explanation of this problem: Column N has dates in the form of Year, Month, because I am comparing that to an Initial Inspection Date in Column C1 through various number of C columns . N1 is the date after a month has past since the Initial Inspection Date and N2 is the after 6 month has past the Initial Inspection date. There is also Column O1 which say “New” and that is being compared to Column D1 through a various number of D Columns. In Column K, titled Notes, after the comparison is done, a status noted base on the Column N, Column C and Column D. My problem is that after 6 month, the Labwork status in column D if not change to close is “Past Due” and I need a way using this equation to note that in Column K. Below is the rest of the details for this problem. Since I can only use 3 argument for an IF statement, how can I add on to the equation to get it to provide the “Past Due Move to Close” status in Column K?

Explanation of this problem: Column N has dates in the form of Year, Month, because I am comparing that to an Initial Inspection Date in Column C1 through various number of C columns . N1 is the date after a month has past since the Initial Inspection Date and N2 is the after 6 month has past the Initial Inspection date. There is also Column O1 which say “New” and that is being compared to Column D1 through a various number of D Columns. In Column K, titled Notes, after the comparison is done, a status noted base on the Column N, Column C and Column D. My problem is that after 6 month, the Labwork status in column D if not change to close is “Past Due” and I need a way using this equation to note that in Column K. Below is the rest of the details for this problem. Since I can only use 3 argument for an IF statement, how can I add on to the equation to get it to provide the “Past Due Move to Close” status in Column K?

Explanation of this problem: Column N has dates in the form of Year, Month, because I am comparing that to an Initial Inspection Date in Column C1 through various number of C columns . N1 is the date after a month has past since the Initial Inspection Date and N2 is the after 6 month has past the Initial Inspection date. There is also Column O1 which say “New” and that is being compared to Column D1 through a various number of D Columns. In Column K, titled Notes, after the comparison is done, a status noted base on the Column N, Column C and Column D. My problem is that after 6 month, the Labwork status in column D if not change to close is “Past Due” and I need a way using this equation to note that in Column K. Below is the rest of the details for this problem. Since I can only use 3 argument for an IF statement, how can I add on to the equation to get it to provide the “Past Due Move to Close” status in Column K?