Calculate days but not saturday and sunday

Anthony Clarke

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes15y ago
Accepted 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 <= endDate)
{
if (!(temp.DayOfWeek == DayOfWeek.Saturday || temp.DayOfWeek == DayOfWeek.Sunday)) count++;
temp = temp.AddDays(1);
}
MessageBox.Show("Number of weekdays is " + count.ToString());
0
Dorababu Meka15y ago
Anthony no problem on marking but finally you got your desired answer which makes us happy
0
Anthony Clarke15y ago
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
0
Dorababu Meka15y ago
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 < s.Days; i++)
            {
                nd = d1.AddDays(i);

                if (nd.DayOfWeek == DayOfWeek.Saturday || nd.DayOfWeek
                == DayOfWeek.Sunday)
                {
                    // ignore
                }
                else
                {
                    businessdayCounter++;
                }
            }
            Console.Write(businessdayCounter);
            Console.Read();
        }
0