function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
sesha boddapatisesha 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
Ajay K DubediAjay K Dubedi
Hi sesha,

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