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...
For G4:G6:
=COUNT(G4:G6)/(COUNT(G4:G6)+COUNTBLANK(G4:G6))
Format the cell with the formula as a percentage.
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 🙂
