I am developing a code where im getting the interval of two dates
for example
DTLeavePayFrom = 1/1/2013
DTLeavePayTo = 1/14/2013

since 1/1/2013 is tuesday and 1/14/2013 is monday, the date diff of both date is 14
but how can i exclude the count of 2 sundays,

i have an existing code of date diff:

        Dim daycount As Integer = DateDiff(DateInterval.Day, DTLeavePayFrom.Value, DTLeavePayTo.Value)

Please help me, Thanks alot!

Label1 will display the number of days....

          Dim count = 0
          Dim totalDays = (DTLeavePayTo.Value - DTLeavePayFrom.Value).Days
          Dim startDate As Date

          For i = 0 To totalDays
               Dim weekday As DayOfWeek = startDate.AddDays(i).DayOfWeek
               If weekday <> DayOfWeek.Sunday Then
                    count += 1
               End If
          Next
          Label1.Text = count

thanks, it helps alot! problem solved :)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.