Calculate Working Days Using Apex In SalesForce

In this blog, we will learn how to calculate the number of working days between two dates excluding Holidays and Weekends.

Introduction 

 

Here, in this blog, we will learn how to exclude holidays (stored in the custom object) and weekends while calculating the number of working days between two given dates.

 

This is kind of a quick tutorial. I was looking for this solution on different forums but couldn't get a proper solution. That's why I have implemented a simple business logic for that. 

 

First, we need to create a custom object which is used to store the details of holidays.

 

 

 

 

Then, let us create an apex class which returns the value of the working days. In this class, we need to create a static method which has two date type parameters; and then, we have to fetch the dates from a custom object using SOQL (Salesforce Object Query Language).

public class BusinessDayCalculation
{
    public static Integer calculateWorkingDays(Date startDate, Date endDate)
    {


        Set<Date> holidaysSet = new Set<Date>();

        for(Holiday__c currHoliday : [Select Date__c from Holiday__c])
        {
            holidaysSet.add(currHoliday.Date__c);
        }

        Integer workingDays = 0;

        for(integer i=0; i <= startDate.daysBetween(endDate); i++)
        {
            Date dt = startDate + i;
            DateTime currDate = DateTime.newInstance(dt.year(), dt.month(), dt.day());
            String todayDay = currDate.format('EEEE');
            if(todayDay != 'Saturday' && todayDay !='Sunday' && (!holidaysSet.contains(dt)))
                {
                    workingDays = workingDays + 1;
                }

        }

        System.debug('--Working days'+workingDays);
        return workingDays;
    }
}

 After that, we have to create one custom field to store the working days.

 

 

For storing the working days in the created custom field, we have to create an apex trigger that updates this custom field with working days. Then, it is returned by an apex class.

trigger LeaveRequestTrigger on Leave_Request__c (before insert, before update)
{
    for(Leave_Request__c LR : Trigger.New)
    {

        Integer workingDays = BusinessDayCalculation.calculateWorkingDays(LR.First_Day_Off__c,LR.Last_Day_Off__c);

        if(LR.Half_Day_AM__c == TRUE && LR.Half_Day_Pm__c == TRUE)
        {
            LR.Working_Days__c = workingDays - 1;
        }

        else if(LR.Half_Day_AM__c == TRUE || LR.Half_Day_Pm__c == TRUE )
        {
           LR.Working_Days__c = workingDays - 0.5;
        }

        else
        {
          LR.Working_Days__c = workingDays;
        }
    }
}

Conclusion

 

Here, in this quick tutorial, we learned how to calculate business working days between two dates excluding holidays and weekends. I hope this guide will help you to calculate such important stuff by using custom business logic.

 

Thanks for reading.