Function help please

[Brian]

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.

 

[Barb Reinhardt]

That sounds like a nightmare to manage. Why don't you break it down into
small pieces. Work with Nationality 1 first. I assume you have a column
in your data set for Nationality. I'd probably do a calculation to
determine what they are eligible for. The challenge is including where they
are to date.