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(); }

Calculate days but not saturday and sunday

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (4)