THANK YOU THANK YOU why didn't I think of that some days it just doesn't come
to me "JE yours was the one I used" but thanks to all who responded!!!!
Tracy

"JE McGimpsey" wrote:

Assuming you only have p's and a's (e.g., weekends and holidays blank),
one way:

=COUNTIF(A1:A31,"p")/COUNTA(A1:A31)

formatted as a percentage.

In article ,
"Tracy" wrote:

I am setting up an attendance sheet with "p" for present "a" for absent what
I want for each child is a percentage of the time in class for that month
being present there??? There are 31 days in a month (some anyways) so there
is my problem, how do I get the percentage because we have saturday & sunday
off plus some months are less than 31 days and I think you excel wizards get
what I mean hopefully I explained it right????