Hello,
I hope someone can help me with this.
If cell C is not blank, result should be "Done"
If the cell is blank and cell B and cell A result should be the following:
If 15 Day Difference, "Too early"
If 30 Day Difference, " Needed"
If 60 Day, "Cancelled"
Here is the data:
Cell C:
Policy Effective
02/16/2021
02/11/2021
02/11/2021
01/22/2021
Cell A & B
Cell A Cell B
02/18/2021 02/16/2021
02/17/2021 02/04/2021
02/12/2021 02/06/2021
02/12/2021 02/06/2021
01/22/2021 01/18/2021
03/01/2021 02/27/2021
Tank you so much
Thank you so much
I hope someone can help me with this.
If cell C is not blank, result should be "Done"
If the cell is blank and cell B and cell A result should be the following:
If 15 Day Difference, "Too early"
If 30 Day Difference, " Needed"
If 60 Day, "Cancelled"
Here is the data:
Cell C:
Policy Effective
02/16/2021
02/11/2021
02/11/2021
01/22/2021
Cell A & B
Cell A Cell B
02/18/2021 02/16/2021
02/17/2021 02/04/2021
02/12/2021 02/06/2021
02/12/2021 02/06/2021
01/22/2021 01/18/2021
03/01/2021 02/27/2021
Tank you so much
Thank you so much