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

​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/24G5 = BLANKG6 = 3/21/24 The total percentage of audits completed is 66%.  Thanks in advance!!!  Read More

​