How Do You Calculate Defect Aging?
How Do You Calculate Defect Aging? A formulae can be applied to defect age time. (defect age in time = defect fixed date – defect detection date) Usually, an average age of all defects, is calculated. How do I calculate aging in Excel? In the third cell, for us it’s C2, enter the following formula: