weekday a numeric designation for the day of the week.
abbreviate is a Boolean value to determine whether or not to abbreviate. Default: False firstdayofweek a constant specifying the first day of the week.
The result is Fri.
UK Date Format
Settings
FirstDayOfWeek
Constant
Value
Description
vbUseSystem
0
First day of week specified in system settings (default)
vbSunday
1
Sunday
vbMonday
2
Monday (complies with ISO standard 8601, section 3.17)
vbTuesday
3
Tuesday
vbWednesday
4
Wednesday
vbThursday
5
Thursday
vbFriday
6
Friday
vbSaturday
7
Saturday
FORM
In a Form you could set the Default Value of a Textbox to
=WEEKDAYNAME(6, 1, 1)
VBA
In a Form add a TEXTBOX control and rename it "txtWeekDayName", then you could add the following in the Load Event.
Private Sub Form_Load()
txtWeekDayName = WeekDayName(6, 1, 1)
End Sub
Course
Want to learn more? Request this via the contact form.
Search
You can find more about this by searching the website.
FORM
VBA
Search
By: 
