WeekdayName

Returns a string representing the day of the week.

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

Key
   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.

Examples

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

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

Related

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