Recently I was asked about a way to calculate the number of week days between two dates. It is simple enough to get the total days by subtracting two dates and then using the resulting TimeSpan object. But what if you want to skip counting Saturday and Sunday? As far as I can tell there is no .NET method to accomplish this. Now watch, as soon as I post this someone will prove me wrong.<\/p>\n
The technique I came up with is to start at the first date and get the day of the week for each consecutive day until the end date. If the day of the week is a weekend, don't count it.<\/p>\n
This is a slightly different way of using a For loop and I got stuck at first until I realized I needed to manually set a new value for $d each time through. After the loop completes $i should be the total number of weekdays. Here's what my complete function looks like.<\/p>\n
\nfor ($d=$Start;$d -le $end;$d=$d.AddDays(1)){
\n if ($d.DayOfWeek -notmatch \"Sunday|Saturday\") {
\n #if the day of the week is not a Saturday or Sunday
\n #increment the counter
\n $i++
\n }
\n...
\n<\/code><\/p>\n