The WEEKDAY function converts a date to a number between one and seven, representing the day of the week.
You could use WEEKDAY to check if a transaction occurs on a weekend.
Syntax
WEEKDAY(Date [, First day of the week])
Arguments
| Argument | Data type | Description |
| Date (required) | Date | The date to return the day of the week for as a number. Returns 1 for Monday, 2 for Tuesday, and so on. |
| Day offset | Number | This argument specifies which day of the week the WEEKDAY function should consider to be the first day of the week. For example, a value of 2 means that WEEKDAY returns a 1 for Tuesday, a 2 for Wednesday, and so on. If omitted, a value of one is used by default. |
The WEEKDAY function returns a number.
Calculation engine functionality differences
In Polaris, you can use a decimal value for the Day offset argument and it is rounded to the nearest whole number. If you use a value outside of 1 to 7, the function returns a value of 0.
In the Classic Engine, you must use a whole number for the Day offset argument.
Syntax example
WEEKDAY(Scheduled payment date)
Excel equivalent
Examples
In this example, a module is dimensioned by a Transactions list. The Transaction date line item has the date data type. The other line items contain formulas.
The Day of the week line item uses the WEEKDAY function with the Transaction date line item. As the First day of the week argument is omitted, 1 represents Monday, 2 represents Tuesday, and so on.
The Day of the week two days later line item also uses the WEEKDAY function. However, 3 is used for the Starting day of the week argument. This means that 1 represents Wednesday, 2 represents Thursday, and so on.
| Transaction date | Day of the week
| Day of the week two days later
| |
| Transaction 001 | 01/03/2022 | 1 | 6 |
| Transaction 002 | 01/04/2022 | 2 | 7 |
| Transaction 003 | 01/05/2022 | 3 | 1 |
| Transaction 004 | 01/06/2022 | 4 | 2 |
| Transaction 005 | 01/07/2022 | 5 | 3 |
| Transaction 006 | 01/08/2022 | 6 | 4 |
| Transaction 007 | 01/09/2022 | 7 | 5 |
