Returns a string representing the day of the week.

      WeekdayName ( number, [abbreviate], [firstdayofweek] )

   date            Any valid date expression.
abbreviate Abbreviate the weekday name? TRUE /FALSE. firstdayofweek A constant that specifies the first day of the week, default=vbSunday.

The WeekdayName() function can be used in VBA or in an SQL query. The vb constants can only be used in VBA.


Dim strDay as String
strDay = weekdayname(2)
will return Monday

“Go girl, seek happy nights to happy days” ~ William Shakespeare


Date - Return the current date.
MonthName - Return a string representing the month.
Format - Format a Number/Date/Time.
Weekday - Return the weekday (1-7) from a date.

Copyright © 1999-2024 SS64.com
Some rights reserved