No, that does not tell me what I need to know. Let's say the student has
completed 7 elements, so you have put the completion dates in these cells...

H7 I7 J7 K7, L7 M7 N7

My question to you is, at the point in time when you enter a date into N7,
how do you know the student is on his/her way to completing a total of 28
elements? How do you know, AT THAT POINT IN TIME, they are not going to end
up doing 34 elements instead of 28? You said the student tell you how many
elements they will be doing. Let's assume the student told you they will be
doing 28 elements... where on your worksheet do you have that 28 entered for
that student? The reason I keep asking you this question is because whatever
number of elements the student told you they will be doing... I have to
divide by that number.

--
Rick (MVP - Excel)


"CelticCharmer" wrote in message
...
Hi Rick and thank you very much for your time.
I input dates into cells H7 I7 J7 K7, L7 M7 N7 O7, V7 W7 X7 Y7, Z7 AA7 AB7
AC7, AH7 AI7 AJ7 AK7, AP7 AQ7 AR7 AS7 and BN7 BO7 BP7 BQ7. I do this as
each
element is completed by the student. Thats 28 cells which will equal
100%.
is this the encoded you require?
Celtic charmer, again thank you for your time.

"Rick Rothstein" wrote:

I don't think I need to see it... all you have to do is tell me how you
know how many elements the student told you he/she would be doing and
where that is encoded on your worksheet. Showing me the worksheet won't
help if this information is not on it; and if it is on the worksheet,
just tell me where.

--
Rick (MVP - Excel)


"CelticCharmer" wrote in
message ...
Is there anyway you can see it? or can I send?

Celtic Charmer



"Rick Rothstein" wrote:

The student tells me at the start what elements they will do.

And where is that information encoded at on the worksheet? I need
either the count of those elements or an indicator of some kind for
the elements each student plans to do so I can count them. In order to
get a percent complete, you have to divide by that count and you
haven't told us, yet, how to read that count from your worksheet.

--
Rick (MVP - Excel)