Attendance Data

  • Thread starter Thread starter DUNNER7
  • Start date Start date
D

DUNNER7

One of the reports I need for my job is average attendance rate for a
student. I know that in Excel there is a formula that will figure total
amount of days (weekdays) if you give it a start date and end date. That
works well if I was calculating 5 school days every week. Is there a way to
code/program/eliminate school holidays and non attendance days that occur
within the work week? If everyone started on the same date and ended on the
same date I could use the formula and just subtract the non school days off
everyone. However, different people may start on different dates so the
total number of days will not be the same for everyone. Is there a way to
designate certain dates so they are not counted. I will be using this data
from my attendance table in my database.

Thanks,
Del Dobbs
 
Robert somehow thinks that posting a message to a newsgroup will unsubscribe
him from it. He might do well to read the Windows Mail help for "Newsgroups".
 
Back
Top