Forum Discussion
Solved
Formula for Percentage Using Dates?
Hi everyone!
I am trying to figure out a percentage formula with audit dates data. I have been trying to find a formula and figured I would ask here!
For example:
G4 = 2/13/24
G5 = BLANK
G6 = 3/21/24
The total percentage of audits completed is 66%.
Thanks in advance!!!
For G4:G6:
=COUNT(G4:G6)/(COUNT(G4:G6)+COUNTBLANK(G4:G6))
Format the cell with the formula as a percentage.
2 Replies
For G4:G6:
=COUNT(G4:G6)/(COUNT(G4:G6)+COUNTBLANK(G4:G6))
Format the cell with the formula as a percentage.
- THANK YOU!!! This worked 🙂
