Attendance Data

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

Del,

I have used this link to calculate working days:
http://www.mvps.org/access/datetime/date0006.htm

The second module on the page link above requires a table made up of holiday
dates.

Anthony


DUNNER7 wrote:
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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200907/1

Unsribe

"DUNNER7" wrote in message
...
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

Unsribe???

" wrote:

Unsribe

"DUNNER7" wrote in message
...
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

On Thu, 2 Jul 2009 18:07:01 -0700, DUNNER7
wrote:

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".

Unsribe???

" wrote:

Unsribe
--

John W. Vinson [MVP]