I am working for a company in Africa that employees many
nationalities, unfortunately for me each nationality has a differing
leave pattern, and I have to keep track of days worked and days leave,
I am having a problem finding a suitable function to calculate leave
and work days, bearing in mind we work 365 days per year.

Nationality 1 works 6 weeks on and 2 off
Nationality 2 works 12 months then 45 days off
Nationality 3 has every Friday off and also gets 45 days leave per
year

I really need to keep track of date start work, date start leave, days
worked, leave taken, and balance, I am having trouble getting the
calculation to work, any help would be very much appreciated.


Brian
Women and cats will do as they please,
and men and dogs should relax and get used to the idea.