You need to sign in to do that
Don't have an account?
sesha boddapati
Caluculate Number of Leaves between to dates
Hi ,
How to Create a formula field for number of leaves taken except saterday, sunday and public holidays .
Is it posible for formula field or not?
Thanks
Sesh
How to Create a formula field for number of leaves taken except saterday, sunday and public holidays .
Is it posible for formula field or not?
Thanks
Sesh
I have understood your requirements. If You have a number of working days of a person(how many days he has worked) then you can make a formula field to count his leaves but it varies +-1 day.
Including Saturday or Sunday total days= 104 or 105 in a year.
You should make a number field for Person's worked days. Then you can easily calculate his leaves.
For example- Steve has worked 225 days in a year. Here is the calculations-
1 year = 365 days
Sat+Sunday = - 104 days
public holidays = - 20 (let)
---------------------
Total working days = 241
Number of Leaves taken = Total working days - Person's worked days
= 241-225 = 16 days
Now formula field should be= 365 - (104 + Number Of public Holidays) - Person's worked days
I hope you find the above solution helpful. If it does, please mark as Best Answer to help others too.
Thanks and Regards,
Ajay Dubedi
www.ajaydubedi.com