Click here to Skip to main content
Click here to Skip to main content

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

By , 10 Nov 2011
 
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 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)

About the Author

John Simmons / outlaw programmer
Software Developer (Senior)
United States United States
Member
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.

Sign Up to vote   Poor Excellent
Add a reason or comment to your vote: x
Votes of 3 or less require a comment

Comments and Discussions

 
You must Sign In to use this message board.
Search this forum  
    Spacing  Noise  Layout  Per page   
GeneralProblem With Code Is this run with C#.Net 2.0 or Only Run i...groupTechnoses29 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...memberRavi LVS10 Nov '11 - 15:32 
This will not count a week day occurrences between two dates. If I want number of Mondays between two dates, your suggestion may not fit in that scenario.
GeneralRe: Well, you changed the tip's content (and subject), so of cou...mvpJohn Simmons / outlaw programmer12 Nov '11 - 12:52 
Well, you changed the tip's content (and subject), so of course this alternative isn't totally applicable now.

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

Permalink | Advertise | Privacy | Mobile
Web02 | 2.6.130523.1 | Last Updated 10 Nov 2011
Article Copyright 2011 by John Simmons / outlaw programmer
Everything else Copyright © CodeProject, 1999-2013
Terms of Use
Layout: fixed | fluid