【VBA】Get the day of the week from the date

You can get
“the day of the week from the date“！

Use the following function:
　Weekday Function
　WeekdayName Function

Contents

VBA Code
Result
FYI

VBA Code

You can get “the day of the week from the date“

Option Explicit

Sub sampleProc()
    
    Dim targetDate As String
    Dim dayOfTheWeek As String
    
    'Set "Date"
    targetDate = Date
    
    'Get "the day of the week"
    dayOfTheWeek = WeekdayName(Weekday(targetDate))
    
    MsgBox (dayOfTheWeek)
    
End Sub

Set “Date“(Line 9).
※This time I’m using “Date Function”.

Get “the day of the week“(Line 12).