Table of Contents
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 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:
- 1/1/2023 is on a Sunday.
- 1/4/2023 is on a Wednesday.
- 2/23/2023 is on a Thursday.
Note: You can find the complete documentation for the VBA WeekdayName function .