Dates into percentages

[Rick Rothstein]

Okay, label Column BX as appropriate (maybe "Total Elements To Be Completed
by Student" or words to that effect) and place the total elements the
student will be completing in that column (that is, type in 28, 34, or
whatever number of total elements the student is scheduled to do). We will
make Column BY your "Percentage Complete" column (you can label it that if
you wish). Put this formula in BY8 and copy it down to the end of your
student list...

=COUNTA(H8:BW8)/BX8

and use Format/Cells to format those cells in Column BY as Percentage.

 

[CelticCharmer]

Hi Rick
Thank you very very much for your help. A good job it works very well again
a big thank you.
Celtic Charmer ;-)