Next Saturday Date using VBA Functions

VBA Next Saturday

Next Saturday Date:

Next Saturday Date using Excel VBA Functions Now, DateAdd,Format and WeekDay. We have different methods and ways to find Next Saturday date. You can find below three specified macros or procedures to find Next Saturday date using VBA functions. i.e Now, DateAdd, WeekDay and Format.

We are trying to find Next Saturday date based on currnt or today’s date. Lets say today’s date is 11th Dec 2018 and weekday is Tuesday then upcoming date of Saturday should be 22nd Dec 2018 and weekday is Saturday. In this tutorial we have explained three methods to find Next Saturday date.

Method1: Get Next Saturday Date using VBA Functions

Let us see the first method to find Next Saturday date.

Sub VBA_Find_Next_Saturday_Method1()
    
    Dim dNext_Saturday As Date

    dNext_Saturday = DateAdd("d", -Weekday(Now) + 14, Now)

    MsgBox "If today's date is '" & Format(Now, "DD MMM YYYY") & "' then" & vbCrLf & _
    " Next Saturday Date is : " & Format(dNext_Saturday, "DD MMM YYYY"), vbInformation, "Next Saturday Date"
    
End Sub

Method2: Get Next Saturday Date using VBA Functions

Here is the second method to find Next Saturday date.

'Method 2: Next Saturday Date using Excel VBA Functions
Sub VBA_Find_Next_Saturday_Method2()
    
    'Variable Declaration
    Dim dNext_Saturday As Date
    
    dNext_Saturday = Now + (14 - Weekday(Now))

    MsgBox "If today's date is '" & Format(Now, "DD MMM YYYY") & "' then" & vbCrLf & _
    " Next Saturday Date is : " & Format(dNext_Saturday, "DD MMM YYYY"), vbInformation, "Next Saturday Date"
    
End Sub

Method3: Get Next Saturday Date using VBA Functions

The third method to find Next Saturday date.

'Method 3: Next Saturday Date using Excel VBA Functions
Sub VBA_Find_Next_Saturday_Method3()

    Dim dNext_Saturday As Date
     
    dNext_Saturday = DateAdd("ww", 1, Now - (Weekday(Now, vbSaturday) - 8))
    
    
    MsgBox "If today's date is '" & Format(Now, "DD MMM YYYY") & "' then" & vbCrLf & _
    " Next Saturday Date is : " & Format(dNext_Saturday, "DD MMM YYYY"), vbInformation, "Next Saturday Date"
        
End Sub

Output Screenshot

You can find following output screenshot of above specified macros.
Next Saturday Date

Instructions:

  • Open Visual Basic Editor by clicking Alt +F11
  • Goto code window by clicking F7
  • Copy any of the above specified procedure or macro
  • Paste above copied code in code window
  • Run macro by clicking F5 or Run command
  • You can see ouput on the screen
  • Find specified output screenshot above.

Related VBA Functions used in this article:

We have used DateAdd, Now, Weekday and Format VBA functions. Click on below specified links to learn more about VBA functions.

VBA DateAdd Function VBA Now Function VBA WeekDay Function VBA Format Function





Leave a Comment

Your email address will not be published. Required fields are marked *