So, is this for each individual student or all students as a group?

Not to sound arrogant or anything like that, but this should be pretty easy
to do. Have you started this project or are you still in the planning stage?

The reason I ask is that if you have something put together and are just
"stuck" I could probably give you some better suggestions if I could see the
file.

Biff

"tannersnonni" wrote in message
...
Gosh thanks for helping...let me see if I can explain.
I need a row with a box for each Sunday of the month. Then the student
will
check the box if they are in attendance. I need a way to see what
percent
of Sundays up to any given point in time they have attended. So if 10
Sundays of the year have passed and they were there 8 of them it would
show
80%. But then the next Sunday rolls by and they don't attend. So the
%Attendence box automatically updates to only 8 out of 11 Sundays present.
Does that make sense? So it is a constant "real time" percentage. Is
that
possible?
THEN... I need a box that shows the actual last date they were in
attendence.
Any help will be greatly appreciated.
maureen

"Biff" wrote:

Hi!

Sounds fairly easy!

What exactly are you having trouble with? Need very specific details,
with
emphasis on details like ranges , formulas, etc.

Biff

"tannersnonni" wrote in message
...
Hi there...I am new here. I am looking for some help. I thought I
knew
how
to use excel with many nested ifs and such but then I tried doing this
one!!
When dates are involved it becomes so confusing. I use excel office xp
professional.
I am trying to set up a sign in sheet for attendance of meetings. Then
I
want a column that sums the number of times attended and the percentage
of
the overall attendance at any given time. So as the months go along
and
time
passes I want the total of days to increase and the percentage to
change
accordingly. So at anytime I could go in and see what percentage a
student
attended class over the number of classes given over the year. Next to
that
column I would like a column that shows the last date attended.
Any help will be GREATLY appreciated. I think dates are so confusing!
thanks so much...maureen