how to exclude Saturday and Sunday from startDate and endDate datetime objects

Question

Developing in c#.I have two DateTime objects. I have to eliminate the Saturday and Sunday from the days count. Lets suppose I have 5 daysincluding Saturday and Sunday. I want to check the days for Saturday Sunday and reduces the days count.

 DateTime startDate = DateTime.ParseExact(startDate.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
 DateTime endDate = DateTime.ParseExact(endDate.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
 TimeSpan diff = endDate - startDate;
 days = diff.Days;

I have tried this,

How can I calculate the Number of Weekends between two dates

but i am unable to eliminate saturday sunday as the given link only eliminate the weekends if the dates difference is greater than 7. Haven't got my solution yet.

Possible duplicate of [Calculate the number of business days between two dates?](https://stackoverflow.com/questions/1617049/calculate-the-number-of-business-days-between-two-dates) — Marcus Höglund, Feb 02 '18 at 12:34
possible duplicate of https://codereview.stackexchange.com/questions/66432/find-the-number-of-working-days-between-two-dates-inclusively — Lalji Dhameliya, Feb 02 '18 at 12:36
excluding means I want to reduce days count if the day is a holiday — Farrukh Sarmad, Feb 02 '18 at 12:38

score 4 · Accepted Answer · answered Feb 02 '18 at 12:35

4

How about a simple loop between the days of the two dates and using DayOfWeek for checking if the day is a Saturday or Sunday?

Something like below should work:

int weekendDays = 0;

for(DateTime date = startDate; date.Date <= endDate.Date; date = date.AddDays(1))
{
    if ((date.DayOfWeek == DayOfWeek.Saturday) || (date.DayOfWeek == DayOfWeek.Sunday))
    {
        weekendDays++;
    }
}

answered Feb 02 '18 at 12:35

Adrian

8,271
2
26
43

Beautiful statement @Adriani – Farrukh Sarmad Feb 02 '18 at 12:40
@BrunoMiquelin proposed [this edit](https://i.imgur.com/rfl1eFS.png) but I'm pretty sure his changes would not produce the right result. – Tagc Feb 02 '18 at 12:54
nice answer but why the extra brackets? – OverMars Feb 07 '23 at 03:58

Bruno Miquelin · Answer 2 · 2018-02-02T12:43:49.063

You cold use the following:

int daycount = 0;
while (startDate < endDate) 
{
    startDate = startDate.AddDays(1);
    int DayNumInWeek = (int)startDate.DayOfWeek;
    if (DayNumInWeek != 0 && DayNumInWeek != 6)
         daycount += 1;       
}

Check This link or This link for more info and options.

Also duplicate of Calculate the number of business days between two dates? , which has a nice LINQ approach by Alpha

To get a better performance and readability, you could implement that.

how to exclude Saturday and Sunday from startDate and endDate datetime objects

2 Answers2