help with vbscript to average a report of dates
 

I am working on trying to average data on an employee report(175
employees and 18 courses). The report list the employee name and if
they took the computer course it populates a cell with the date
completed. If the course was not taken it leaves the field blank. I
need to know the % of courses completed for each employee and the %
total completed for all employees. This report can be ran daily so I
need something easy to transfer. I am effluent in vb and access but
can't figure out the best way to program this. Thank you for any help
in advance.

Ex)

Column1(Name) Column 2(Course Name)
Employee name Date of completion