Forum Discussion
Formula to display a column of expirey dates as a percentage of items still current
I am creating an excel 2010 spreadsheet to record the inspection dates for electrical equipment that includes a column to enter the next test due date (expirey). The intent is to have a single cell in a seperate worksheet to summerise all in date equipment (inspection dates that have not yet expired) as a percentage. The idea is to be able to view a cell to obtain an instant percentage value of compliance, eg, if all equipment has been inspected and the next inspection date due is in the future, the result will be 100%. If half of the recorded equipment is overdue for its next inspection (expired) the cell will display 50%. An example of the date format is 29 Jun 18.
Any advice would be greatly appreciated. Thank you for taking the time to view my post.
Gav
Any advice would be greatly appreciated. Thank you for taking the time to view my post.
Gav
4 Replies
- Thank you very much for your advice. I will try this later today and let you know the outcome. Thanks again.
That could be like
=COUNTIF(<your due dates range>,">"&TODAY())/COUNTA(<your due dates range>)
how would I do if I had three variables (Expired, Expiring Soon, Compliant)?
- Thank you very much for your advice. I will try this later today and let you know the outcome. Thanks again
