Formula to count days a row stays in a certain status?
For a contract management sheet, we are using a drop down single-select to choose the contracts status, ie. new request, attorney review, awaiting signature... I want to measure the average time any row stays in a certain status. The idea is that we can track how many days on average attorney review takes, or how many days contracts spend awaiting signature, etc.
Any help is appreciated, thank you.