Forum Discussion
Solved
Calculating percentage of column in date range
I am trying to work out a way of calculating the percentage of staff who have completed training within the last year within a column to flag up our overall training compliance. I have already used...
Try:
=COUNTIF($B$2:$B86,">="&TODAY()) / COUNT($B$2:$B86)
Fantastic all up and working. Thank you so much!