how to calculate days

[ياسر]

I work in company that takes 2 days for weekend it's Friday and Saturday
and all the holidays that may be more than one day such as Eid El Adha
is more than 3 days continuously.
So i made a form for entering the vacation for each employee in the company
like the following :
the main form :
Emp name , Department , and then the sub form like the following:
Date from , Period , Date to , kind of vacation
So how to calculate the vacations days for the emp without counting any of
the weekend days or holidays that's may me more than 3 or 4 days as i said
before.
like : emp takes 10 days vacation from 1/12/2008 To 10/12/2008 so there is
Friday and Saturday counted i don't want them to be counted so the condition
is that the Emp vacation is to be ended in 12/12/2008 or if there is any
other holidays in between the vacation for the Employee.
please replay me because i need the solution very quickly .
sorry for the long text i wrote .

 

[RBear3]

Personally, I don't include those days in the entry. If I take vacation
from Wednesday through the following Tuesday, it would be two entries. One
for Wed-Fri and one for Mon-Tues.

If I take off the Wednesday before Christmas (which is on Thursday and we
also get off Friday) and I also take off the Monday after Christmas, then I
would make two entries. I did not take vacation from Dec 24 through Dec 29.
I took off the 24th and the 29th.

Hope that helps.

RBear3

 

[ياسر]

Personally, I don't include those days in the entry. If I take vacation
from Wednesday through the following Tuesday, it would be two entries. One
for Wed-Fri and one for Mon-Tues.

If I take off the Wednesday before Christmas (which is on Thursday and we
also get off Friday) and I also take off the Monday after Christmas, then I
would make two entries. I did not take vacation from Dec 24 through Dec 29.
I took off the 24th and the 29th.

Hope that helps.

RBear3





Sorry this is not I want

Because every employee has an account limit for the vacation its 21 days for
whom have experience for 1 year To 10 years for the current year OR 30 days
for whom that have experience more than 10 years or more every current year
So I need to calculate the days that he toke throw the current year as i
wrote before .
is there any way to do by using the form with sub form that i made above
main form contains the information for the Employee
sub form contains the processing for the vacations details
date from - period - date to - kind of the vacation.
please help very quickly.
thank you for replaying.

 

[ياسر]

please i need to do this job
so help me in maintains it with code as i explain before
thanks for reading and waiting for help