Program to determine number of working days

[MJV57]

Im looking for an algorithm to use to determine the number of working days remaining in a job. I will feed the start date and the end date but we only work Monday to Friday. Does anyone know how I could do this or have an example.

 

[jmeckley]

public int NumberOfWorkDays(DateTime start, DateTime end)
{
   var days = 0;
   var current = start;
   while(current <= end)
   {
       if(current.DayOfWeek == DayOfWeek.Saturday || current.DayOfWeek == DayOfWeek.Sunday) continue;
        days++;
   }
   return days;
}

Jason Meckley
Programmer
Specialty Bakers, Inc.

faq855-7190
faq732-7259

 

[MichaelRed]

ut you will (eventually) need to include provision(S) TO SKIP "LEGAL" holidays. I use a simple table with the holiday name and date, with a lookup to also check them.




MichaelRed

 

[MJV57]

Jason how do I tie your code into a database with many jobs with many start and end dates to calculate the days remaining for each job
Thanks

 

[jmeckley]

if you want to do this work on the database then use tsql. for an optimized approach i would ask in a forum dedicated to that database/tsql dialect.

Jason Meckley
Programmer
Specialty Bakers, Inc.

faq855-7190
faq732-7259