Find every saturday and sunday in an interval of two dates

[Satoshi96]

Hello. I've been working on a program for several days and I already have a few thousands of lines of codes written. But I'm facing with a big dilemma right now.

I'm kind of new to .NET, I'm working in Visual Studio 2013. I'm trying to find an easiest way to do the following:

I've got these objects:

DateTimePicker1
DateTimePicker2
ListBox1
Button1
Label1
Label2

In the DateTimePicker1, the user chooses the starting date. Let's say 1. january 2014.
In the DateTimePicker2, the user chooses the ending date. Let's say 1. july 2014.

Now, what I need the program to do is that when the user clicks on Button1, the following will show up in Label1 and Label2:

Label1 will show total days in a number in between the dates chosen in DateTimePicker 1 and 2.
label2 will show total days in a number in between the dates chosen in DateTimePicker 1 and 2 WITHOUT every sunday and saturday that occurs in between these two dates.

Also, every saturday's and sunday's dates in between the dates chosen in DateTimePicker 1 and 2 will be added to the ListBox1.

Is there anyone who could help me out? It's an important project to me and I still have about 40% of coding left, but this is stopping me. I can't continue working on my program until I get this solved. Thank you very much.

[Rabbit]

What have you tried so far and what errors are you getting?

[Satoshi96]

Well I was trying lots of things. I know the code to count all of the days in between that interval:

Dim date1 As Date
Dim date2 As Date
 
date1 = Convert.ToDateTime(DateTimePicker1.Value)
date2 = Convert.ToDateTime(DateTimePicker2.Value)
Dim diff As System.TimeSpan = date2 - date1
Label1.Text = diff.Days + 1

And I was trying to use While, For and so on to somehow get all the dates of weekdays to be written in the ListBox1, but I can't figure out a proper way.

I found some code to count all of the fridays in a specified date range, but it didn't fit my case. Also, I couldn't get the dates to be written in ListBox1 as separate items. And due to it's format being DateTime, not Date even after I wrote Date only, it was writing the items as e.g. 25.4.2014; 17:32... but I don't want the time to be there. I believe it's due to the DateTimePicker's DateTime only format being available.

[Rabbit]

Please show me the loop you tried.

[Satoshi96]

I've got my question already answered. Thank you anyways :)

http://stackoverflow.com/questions/2...s-interval-net