Happy Codings - Programming Code Examples

Html Css Web Design Sample Codes

CPlusPlus Programming Sample Codes

JavaScript Programming Sample Codes

C Programming Sample Codes

CSharp Programming Sample Codes

Java Programming Sample Codes

Php Programming Sample Codes

Visual Basic Programming Sample Codes

Visual Basic Programming Code Examples

Visual Basic > Date Time Code Examples

Adding a number of weekdays to a date



Adding a number of weekdays to a date

The simple function adds a number of weekdays to a date.

'Purpose   :    Adds a number of weekdays to a specified date.
'Inputs    :    dtDate              The starting date
'               lNumDays            The number of days to add.
'Outputs   :    The starting date plus the number of specified weekdays

'Notes     :    For Excel change the header to:
'
'               Function WeekDayAdd(ByVal dtDate As Date, ByVal lNumDays As Long) As Date
'                   Dim lDaysAdded As Long, eWeekday As VbDayOfWeek
'                   Dim lAdd As Long
'                   Application.Volatile True
'                   On Error GoTo ErrFailed
'
'               To use the function in worksheets
'Revisions :

Function WeekDayAdd(ByVal dtDate As Date, ByVal lNumDays As Long) As Date
    Dim lDaysAdded As Long, eWeekday As VbDayOfWeek
    Dim lAdd As Long
    
    On Error GoTo ErrFailed
    If lNumDays < 0 Then
        lAdd = -1
    Else
        lAdd = 1
    End If
    
    Do While lDaysAdded <> lNumDays
        dtDate = dtDate + lAdd
        eWeekday = Weekday(dtDate)
        If eWeekday > vbSunday And eWeekday < vbSaturday Then
            lDaysAdded = lDaysAdded + lAdd
        End If
    Loop
    WeekDayAdd = dtDate
    Exit Function

ErrFailed:
    Debug.Print Err.Description
    Debug.Assert False
End Function

C Program Check the String is Palindrome
C program code to 'Check whether a String' is palindrome or not without using loop. How to Check whether a string is 'Palindromic String' or not in C. Palindrome string is special string

C Swap 2 Numbers using Bitwise Operator
Swap two number using bitwise operator in C programming. There are tons of discussions going around the internet to swap 2 numbers without using temporary variable. We can...

Program Code to Implement Linear Search
C implements 'Linear Search'. Linear search is also called as sequential search. Linear search is a method for Finding a Particular value in a list, that consists of checking every one of its

C Programs Calculates the Value of sin(x)
C Program Coding to Calculates the Value of sin(x). It's a non-differentiable function. Start at zero, then goes up to 1, then back down to 0. But then, instead of Going Negative, it will

C++ Pointers to Pointer or Double Pointer
Dereference operator or indirection operator, noted by asterisk, is also a "unary operator" in C++ languages that uses for pointer variables. 'Double Pointer' or Pointer to Pointer need to

C Program LCM while loop & if statement
The LCM of two integers num1 and num2 is the smallest positive integer that is perfectly divisible by both num1 and num2 (without a remainder). For example: the LCM of 72 and

C Implementing Selection Sort Recursively
This C Program implements a Selection Sort. 'Selection Sort' works by finding the smallest unsorted item in the list and swapping it with the item in the current position. It is used for

C Sort Structures on the basis of Structure
Using cricket, declare an array player with 10 elements and write a c program to read the information about all the 10 players and print a team wise list containing names of players