Salesforce: Adding specific working days to a Date

UPDATE: If you want to consider holidays and business hours you can check out this article.

Many time while coding we come across the requirement in which we need to calculate the EndDate from a StartDate after a specific number of business/working days. That means excluding the weekends (Saturday & Sunday) Following is the code snippet which does this. I know there can be an optimized way of doing this. But I didn’t want to spend more time on this.

Below method takes date and number of working days to be added to the date.

Method daysOff calculates the number of non-working days coming in the start date and end date. And after which we are again adding those number of days.

6 thoughts on “Salesforce: Adding specific working days to a Date”

  1. Hi

    After adding daysOff to the endDate what if the date comes out to be a weekend?
    You’ve not handled that situaution.

  2. Hi If I want to exclude Fri and Sat as weekends and modify this formula so that it calculates the number of working days instead of a date, what changes do I need to make to this formula?

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.