WeekDay Function

This function returns the number corresponding to the weekday represented by a serial date number that is generated by the DateSerial or the DateValue functions.

note

This help page describes the WeekDay function used in Basic scripts. If you are interested in the WeekDay function used in LibreOffice Calc, refer to this help page.


Sintaxi:


  WeekDay (SerialDate, [FirstDayOfWeek])

Paràmetres:

SerialDate: Integer expression that contains the serial date number that is used to calculate the day of the week.

FirstDayOfWeek: Integer value indicating which weekday should be considered as the first day of the week. The default value is 0, meaning that the system locale settings are used to determine the first day of the week.

The parameter FirstDayOfWeek accepts values ranging from 0 to 7. The table below describes the meaning of each possible value:

Valor

VBA Constant

Descripció

0

vbUseSystemDayOfWeek

Use system locale settings

1

vbSunday

Diumenge (per defecte)

2

vbMonday

Dilluns

3

vbTuesday

Dimarts

4

vbWGlh2 id="h850603" dir="auto">• Per a carregar macros BASIC cal fer servir la biblioteca ="Calc Icon" style="width:60px;height:60px;">Impress Icon /sc<31619718840122" class> /sc<31619718840122" class>

Exemple061421171139088233" dir="auto">Exemple061421171139088233" dir="auto">Exemple06cal dnr 1139088233" dir="auto">Exeid="relaExeid="relaReturns True when A is less than B.

Siia/navigation/libo-impress.svg" alt="Impress Ici}nter

shar"autoSunday