Current Saturday Date of This Week using VBA Functions

Date - Time Functions, Excel, Functions, Programming / , , , , , , , ,
VBA Current Saturday

Current Saturday Date using Excel VBA Functions Now, DateAdd,Format and WeekDay. We have different methods and ways to find Current Week Saturday date. You can find below two specified macros or procedures to find Current week Saturday date of this week using VBA functions. i.e Date, DateAdd, WeekDay and Format.

We are trying to find current week Saturday date based on current or today’s date. Lets say today’s date is 13th Dec 2018 and weekday is Saturday then current date of Saturday should be 15th Dec 2018 and weekday is Saturday. In this tutorial we have explained three methods to find Current week Saturday date. To avoid using time, you can replace Date with Now. Then there is no difference in output.

Table of Contents:

Method1: Get Current Week Saturday Date using VBA Functions

Let us see the first method to find current week Saturday date of this week.

'Method 1: Current Saturday Date using Excel VBA Functions
Sub VBA_Find_Current_Saturday_Method1()
    
    Dim dCurrent_Saturday As Date

    dCurrent_Saturday = DateAdd("d", 8 - Weekday(Date, vbSaturday), Date)

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

Method2: Get Current Week Saturday Date using VBA Functions

Here is the second method to find Current week Saturday date of this week.

'Method 2: Current Saturday Date using Excel VBA Functions
Sub VBA_Find_Current_Saturday_Method2()
    
    'Variable Declaration
    Dim dCurrent_Saturday As Date
    
    dCurrent_Saturday = Date - Weekday(Date, vbSaturday) + 8

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

Method3: Get Current Week Saturday Date using VBA Functions

Let us see the third method to find Current week Saturday date of this week.

'Method 3: Current Saturday Date using Excel VBA Functions
Sub VBA_Find_Current_Saturday_Method3()
    
    'Variable Declaration
    Dim dCurrent_Saturday As Date
    
    dCurrent_Saturday = 7 - Weekday(Date) + Date

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

Output Screenshot

You can find following output screenshot of above specified macros.
Current 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 Date Function VBA WeekDay Function VBA Format Function

Leave a Comment