Awesome I finally completed it. Thanks so much I just used "count(range) / #
of employees" I think I was trying to make it more complicated than it should
be. Once again thank you!!!!

"FSt1" wrote:

hi
you're a bit foggy about how your data is layed out so i'm going to assume
alot.
assume that you have 6 employees in column a2:A7.
assume that 3 of those employees have a train date in column b2:B7.
in C2 put....
=count(B2:B7)/Counta(A2:A7) format as percent.
or if you know the number of employees...
=count(B2:B7)/6

anyway that's the idea.
adjust the above formula to suit your data.

Regards
FSt1

"Anthony P." 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?