Dear All
Currently we have annual leave (paid leave) of 30 days calendar days in a year. It is calculated 2 and Half days per month and it includes the week offs. Now we wanted to change the annual leave to working days ie 22 days in a year with 8 days week offs.
I need formula to count the annual leave in every day basis.
Suppose my date of joining in the company is 20.04.14 and what will be leave balance today.
Presently when we are entering the total leave requested and leave start date system automatically calculates the end date and others.
So i need the same if we ask leave for 25 days and it should remove the week offs and total leave days should be 25 days.
Please help on this.
Regina
Currently we have annual leave (paid leave) of 30 days calendar days in a year. It is calculated 2 and Half days per month and it includes the week offs. Now we wanted to change the annual leave to working days ie 22 days in a year with 8 days week offs.
I need formula to count the annual leave in every day basis.
Suppose my date of joining in the company is 20.04.14 and what will be leave balance today.
Presently when we are entering the total leave requested and leave start date system automatically calculates the end date and others.
So i need the same if we ask leave for 25 days and it should remove the week offs and total leave days should be 25 days.
Please help on this.
Regina