Calculate days but not saturday and sunday

Question

Hi Im try to caluclate days from two datetimepickers datetimepicker 1 = startdate dattimepicker2 = end date How would i go about calculating the days between the 2 datetimepicker but remove the saturdays and sundays from it? Thanks in advance Anthony

Vulpes · Answer

Off the top of my head something like this should work: DateTime startDate = dateTimePicker1.Value; DateTime endDate = dateTimePicker2.Value; DateTime temp = startDate; int count = 0; while (temp { if (!(temp.DayOfWeek == DayOfWeek.Saturday || temp.DayOfWeek == DayOfWeek.Sunday)) count++; temp = temp.AddDays(1); } MessageBox.Show(Number of weekdays is  + count.ToString());

Dorababu Meka · Answer

Anthony no problem on marking but finally you got your desired answer which makes us happy

Anthony Clarke · Answer

Hi Thankyou both for your quick response they are both perfect but ill mark Vulpes as the correct answer as he was first to reply. Thats the only fair way i can think of. Thank you very much for your help though Dorababu M Thanks alot Vulpes your a star

Dorababu Meka · Answer

Sample code static void Main(string[] args) { DateTime d1 = Convert.ToDateTime(6/17/2011); DateTime d2 = Convert.ToDateTime(6/22/2011); TimeSpan s = d2.Subtract(d1); DateTime nd; int businessdayCounter = 0; for (int i = 0; i { nd = d1.AddDays(i); if (nd.DayOfWeek == DayOfWeek.Saturday || nd.DayOfWeek == DayOfWeek.Sunday) { // ignore } else { businessdayCounter++; } } Console.Write(businessdayCounter); Console.Read(); }