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...
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
