12,300,379 members (52,368 online)
alternative version

48.9K views
22 bookmarked
Posted

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

, 25 Dec 2011 CPOL
 Rate this:
Find the count of a weekday between two dates without iterating/looping

When you want number of Thursdays or any other week day between two dates, there is no direct function in .NET. To fill the gap, I have written the following function that gives the count of a weekday between two given dates. This function is constructed without using iteration/loop statements.

```public static int  findWeekCount(DateTime startDate, DateTime toDate, DayOfWeek Week)
{
int _daysBetweenDates = (toDate - startDate).Days;  // days between start date and end date
int _adjustingDays = (7 + (int)Week - (int)startDate.DayOfWeek) % 7; // days between week of start date and searching week
int _oddDays = _daysBetweenDates % 7; // remainder of total days after dividing 7

int _completeWeekTurns = (_daysBetweenDates) / 7;

}```

Usage:

```DateTime sDate = new DateTime(2011, 09, 1);
DateTime eDate = new DateTime(2011, 11, 30);
DayOfWeek fWeek = DayOfWeek.Monday;

int totCount = findWeekCount(sDate, eDate, fWeek);
MessageBox.Show(totCount.ToString()); //Result : 13 (Mondays)```

Hope this is useful. Any alternative is highly appreciated.

Share

 India
No Biography provided

You may also be interested in...

 First Prev Next
 How get the list of sundays between 2 specified dates in vb.net sushant.khot3126-Aug-12 11:35 sushant.khot31 26-Aug-12 11:35
 Last Visit: 31-Dec-99 18:00     Last Update: 29-May-16 11:15 Refresh 1

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

Web02 | 2.8.160525.2 | Last Updated 25 Dec 2011
Article Copyright 2011 by Ravi LVS