Hi,
I decided to start a new thread for this, as I was unable to get the old one working. I need assistance with a formula to find the status of a record and the amount of days it is Pending.
In column H = Start Date, N=Execution Date, O = Status (that has several status types), Q = Time Frame to completion (which may have several options such as Not Executed, 2-2-4 weeks, 3 - 1-3 months, 4-3+months)
What I am looking for the Pending Days column is: If the Status = Will not be Executed and Time Frame = Not Executed, then present "Ignore". If Status = Active and Time Frame has a value (such as 2-2-4 weeks), = Ignore. If the Status = any other status and the Time Frame = Not Executed, then subtract Today's Date from the Start Date, and the date calculation displays <30 days, show < 30 days. If date calculation is between 30-60 days, show 30-60 days. If the date calculation is 60-90 days, show 60 - 90 days, and if >90 days, show > 90 days.
Any assistance with this will be helpful.
Thank you.
I decided to start a new thread for this, as I was unable to get the old one working. I need assistance with a formula to find the status of a record and the amount of days it is Pending.
In column H = Start Date, N=Execution Date, O = Status (that has several status types), Q = Time Frame to completion (which may have several options such as Not Executed, 2-2-4 weeks, 3 - 1-3 months, 4-3+months)
What I am looking for the Pending Days column is: If the Status = Will not be Executed and Time Frame = Not Executed, then present "Ignore". If Status = Active and Time Frame has a value (such as 2-2-4 weeks), = Ignore. If the Status = any other status and the Time Frame = Not Executed, then subtract Today's Date from the Start Date, and the date calculation displays <30 days, show < 30 days. If date calculation is between 30-60 days, show 30-60 days. If the date calculation is 60-90 days, show 60 - 90 days, and if >90 days, show > 90 days.
Any assistance with this will be helpful.
Thank you.