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

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

Aniket Yadav · Answer 1 · 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

CRDave1988 · Answer 2 · 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

Frederico Barbosa · Answer 3 · 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;
        }

    }
}

SteveAdey · Answer 4 · 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);

To Calculate number of days with date selected

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0

To Calculate number of days with date selected

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us