Calculate no of weekdays in date range

[James1981]

Hi,

Is there an easy way to calculate the no of weekdays (not weekends) in a specified date range?

Cheers
James

 

[gazzeruk]

Hi,

Following does the job - maybe not so elegant - but it works!

   DateTime start = new DateTime(<start date>); //see DateTime constructor for various formats of <start date>
   DateTime end = new DateTime(<end date>);
   int count = 0;
   for (DateTime dt=start; dt<end; dt=dt.AddDays(1))
   {
      if (dt.DayOfWeek!=DayOfWeek.Saturday && dt.DayOfWeek!=DayOfWeek.Sunday)
         count++;  
   }
   //count is now num of weekdays in period

Cheers,

Gary