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

Code Support Infinite Precision Arithmetic - C Program code creates a support for Infinite Precision Arithmetic which allows storage of Large Integers which is beyond the Range of the integral limit. C is architecture dependent

C Program Reverse a String Use Recursion - Program reverse the string 'Using Recursion'. C program uses recursive function & reverses the string in the same 'Memory Location'. Eg 'Superman8' will be reversed to '8namrepuS'

Any number of Digits Armstrong Sample - An "Armstrong Number" is a number that is the 'sum of its own digits' each raised to the power of the number of digits is equal to the number itself. Some Armstrong numbers is 0

Find the Largest Number Present in Array - To find the largest element in an array in C++ programming, enter the array size, enter the array elements. Start finding for the Largest element in the array to "Display the Largest"

Sum the Integers from 1 to users number - Sum the integers from 1 to a user-specified number in C programming language. Declare the number of integers to be summed. The loop counter. Sum integers from 1 to count.

The C++ Language Returning a Reference - As a function can be created to return a value of a primitive type, a function can be defined to return a reference to primitive type. When 'declaring such a function', you must indicate

C Programming Bubble sort [Linked List] - If the list is empty, create first node. Go to last node. Add node at the end. Preform a bubble sort on the linked list. The 'c' node precedes the 'a' and 'e' node pointing up...

Find an Input Substring in an input main - C Programming example code to find an input substring in an input main string. The given sub-string is present in the main string. The given sub-string is not present in the...