To Calculate number of days with date selected

Question

0.00/5 (No votes)

See more:

Hi

I have two calendar controls one for From and the other for To and from the two dates selected i have to calculate the number of days and also i have to exclude the saturdays and sundays (i.e) if i have applied for leave from friday till monday I have to exclude sat and sunday and calculate the leave as 2 how to do it

Posted 7-Feb-12 1:35am

Shashwath7

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

SteveAdey · Answer 1 · 2012-02-07T02:41:00

Write an extension method to exclude the weekends.

public static class ExtensionMethods
{
    public static int GetNumberOfWorkingDays(this DateTime startDate, DateTime endDate)
    {
        int numberOfWorkingDays = 0;

        for (var nextDate = startDate; nextDate < endDate; nextDate = nextDate.AddDays(1))
        {
            if (nextDate.DayOfWeek != DayOfWeek.Saturday && nextDate.DayOfWeek != DayOfWeek.Sunday)
            {
                ++numberOfWorkingDays;
            }
        }

        return numberOfWorkingDays;
    }
}

and then call it from your code, e.g.

C#

var startDate = DateTime.Now;
var endDate = startDate.AddDays(10);
var numberDays = startDate.GetNumberOfWorkingDays(endDate);

Frederico Barbosa · Answer 2 · 2012-02-07T02:35:00

One can always iterate... if the dates aren't too far apart. This code snippet assumes there are no holidays.

C#

using System;

namespace Codeproject.Answers
{
    public static class BusinessDaysCounter
    {
        public static long LeaveDays(DateTime from, DateTime to)
        {
            if (to < from)
            {
                return LeaveDays(to, from);
            }

            long days = 0;
            DateTime d = from;
            while (d <= to)
            {
                if (d.DayOfWeek != DayOfWeek.Saturday && d.DayOfWeek != DayOfWeek.Sunday)
                {
                    days++;
                }
                d = d.AddDays(1);
            }

            return days;
        }

    }
}

CRDave1988 · Answer 3 · 2012-02-07T01:59:00

Solution 2

http://social.msdn.microsoft.com/Forums/en-US/csharpgeneral/thread/0625cefa-461b-4a3c-b7f0-d39d06741b70/[^]

Calculating Business Hours[^]

Posted 7-Feb-12 1:59am

CRDave1988

Aniket Yadav · Answer 4 · 2012-02-07T01:53:00

Solution 1

Here You Can Get The Total Number Of Days Between The Two Dates

C#

DateTime d1=DateTime.MinValue;
DateTime d2=DateTime.MaxValue;
TimeSpan span = d2 - d1;
Console.WriteLine
         ( "There're {0} days between {1} and {2}" , span.TotalDays, d1.ToString(), d2.ToString() );

For The Leaves You Have to Write A Separate Routine And Then Subtract It From Total Days.

Then You Will Get The Exact Number Of Days.

Posted 7-Feb-12 1:53am

Aniket Yadav

Comments

Aniket Yadav 7-Feb-12 8:20am

Accept The Answer If It Has Helped You

Sergey Alexandrovich Kryukov 1-Mar-12 11:55am

Right, a 5.
--SA

To Calculate number of days with date selected

4 solutions

Solution 4

Solution 3

Solution 2

Solution 1

Add your solution here

Preview 0