How to add a number of days to a Date while skipping weekends and other holidays and start day is weekend or holiday

Question

Below code calculates the number of workdays to be added and if the end date falls on holidays/weekends, shift the date to the next day.
But this code is on an assumption that the start date is not on weekends/holidays.

I want the code which also works if the start date falls on a weekend/holiday.

Please note this code was posted by ElenaSofea on 17 Jun'13 but as I was not able to comment on it asking this as a new question.
Reference: How to add a number of days to a Date while skipping weekends and other holidays

static DateTime CalculateFutureDate(DateTime fromDate, int numberofWorkDays,   
                                ICollection<DateTime> holidays)
{
    var futureDate = fromDate;
    for (var i = 0; i < numberofWorkDays; i++ )
    {
        if (futureDate.DayOfWeek == DayOfWeek.Saturday 
         || futureDate.DayOfWeek == DayOfWeek.Sunday
         || (holidays != null && holidays.Contains(futureDate)))
        {
            futureDate = futureDate.AddDays(1);
            numberofWorkDays++;
        }
        else
        {
            futureDate = futureDate.AddDays(1);
        }
    }
    while(futureDate.DayOfWeek == DayOfWeek.Saturday 
         || futureDate.DayOfWeek == DayOfWeek.Sunday
         || (holidays != null && holidays.Contains(futureDate)))
    {
        futureDate = futureDate.AddDays(1);
    }
    return futureDate;
}

you really should take a look on http://jollyday.sourceforge.net/ — Leo, Apr 14 '14 at 13:06
This is not a Java question. I retagged it as C# since the source code that you copied comes from a C#-tagged post. — Erwin Bolwidt, Apr 14 '14 at 15:07

score 0 · Answer 1 · edited Apr 14 '14 at 14:37

0

Try to pass the date as input, such that this method validates to check whether it is saturday or sunday

public static boolean isValidateSundayorSaturday(String date) throws Exception {

        Calendar calendar = Calendar.getInstance();     
        if (date != null) {

            calendar.setTime(getDate(date,null));
            int day = calendar.get(Calendar.DAY_OF_WEEK);

            if (day == Calendar.SUNDAY || day == Calendar.SATURDAY) {
                return true;
            } 
        }
        return false;
    }

edited Apr 14 '14 at 14:37

Paul Richter

10,908
10
52
85

answered Apr 14 '14 at 13:12

Sireesh Yarlagadda

12,978
3
74
76

1

Changed as per the java code base, instead of js @PaulRichter – Sireesh Yarlagadda Apr 14 '14 at 13:58

score 0 · Answer 2 · edited May 23 '17 at 11:49

0

You've to provide all excluded dates because it is different from region to region even in same country.

If you want to see code here you go

edited May 23 '17 at 11:49

Community

1
1

answered Dec 19 '14 at 10:07

rana

145
1
2
8

How to add a number of days to a Date while skipping weekends and other holidays and start day is weekend or holiday

2 Answers2