You could try:
=COUNT(range)/COUNTBLANK(range)

As Mike pointed out, your shift requirement would have to be
determined somehow unless the ranges are grouped by shift.

On Jun 9, 1:55 pm, Anthony P. <Anthony
wrote:
I am trying to find the percetange of cells that contain values. The cells
contain dates of trainings that my staff attended. I want the formula to
count the number of cells that have dates in them and then divide by the
total of number of staff on that shift. Can I accomplish that in one cell?