Click here to Skip to main content
15,355,133 members
Articles / Web Development / ASP.NET
Alternative
Tip/Trick
Posted 10 Nov 2011

Tagged as

Stats

13.2K views

Find the count of a weekday between two dates without iterating/looping

Rate me:
Please Sign up or sign in to vote.
5.00/5 (3 votes)
10 Nov 2011CPOL
How about this?public static class ExtendDateTime{ public int CountWeekDays(this DateTime thisdate, DateTime thatDate) { int days = Math.Abs((thisDate - thatDate).Days) + 1; return = ((days/7) * 5) + (days % 7); }}Usage would be like this:DateTime...
How about this?
C#
public static class ExtendDateTime
{
    public int CountWeekDays(this DateTime thisdate, DateTime thatDate)
    {
        int days = Math.Abs((thisDate - thatDate).Days) + 1;
        return = ((days/7) * 5) + (days % 7);
    }
}

Usage would be like this:
C#
DateTime startDate = new DateTime(2011, 11, 1);
int weekdays = startDate.CountWeekDays(new DateTime(2011, 11, 30));


BTW, if you haven't noticed, this extension method works whether the date being compared occurs in the future OR in the past.

License

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

Share

About the Author

#realJSOP
Software Developer (Senior) Paddedwall Software
United States United States
I've been paid as a programmer since 1982 with experience in Pascal, and C++ (both self-taught), and began writing Windows programs in 1991 using Visual C++ and MFC. In the 2nd half of 2007, I started writing C# Windows Forms and ASP.Net applications, and have since done WPF, Silverlight, WCF, web services, and Windows services.

My weakest point is that my moments of clarity are too brief to hold a meaningful conversation that requires more than 30 seconds to complete. Thankfully, grunts of agreement are all that is required to conduct most discussions without committing to any particular belief system.

Comments and Discussions

 
GeneralProblem With Code Is this run with C#.Net 2.0 or Only Run i... Pin
Technoses29-Dec-11 20:18
MemberTechnoses29-Dec-11 20:18 
Problem With Code
Is this run with C#.Net 2.0 or
Only Run in earlier version...
GeneralThis will not count a week day occurrences between two dates... Pin
Ravi LVS10-Nov-11 15:32
MemberRavi LVS10-Nov-11 15:32 
GeneralRe: Well, you changed the tip's content (and subject), so of cou... Pin
#realJSOP12-Nov-11 12:52
mva#realJSOP12-Nov-11 12:52 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.