How to Use WeekdayName Function in VBA (With Example)

You can use the WeekdayName function in VBA to obtain the name of the day of the week from a given date.

Here is one common way to use this function in practice:

Sub FindWeekdayName()
    
Dim i As Integer

For i = 2 To 9
    Range("B" & i) = WeekdayName(Weekday(Range("A" & i)))
Next i
    
End Sub

This particular macro will find the name of the weekday for each date in the range A2:A9 and display the results in the range B2:B9.

The following example shows how to use the WeekdayName function in practice.

Note: If you would rather return the day of the week as an integer then you should use the Weekday function instead.

Example: How to Use WeekdayName Function in VBA

Suppose we have the following column of dates in Excel:

Suppose we would like to obtain the name of the weekday for each date and display the results in column B.

We can create the following macro to do so:

Sub FindWeekdayName()
    
Dim i As Integer

For i = 2 To 9
    Range("B" & i) = WeekdayName(Weekday(Range("A" & i)))
Next i
    
End Sub

When we run this macro, we receive the following output:

Column B displays the name of the weekday for each date in column A.

For example:

And so on.

Note: You can find the complete documentation for the VBA WeekdayName function here.

The following tutorials explain how to perform other common tasks in VBA: