Weekday

return the weekday of a Date/Time value, ranging from 1 (Sunday) to 7 (Saturday) by default.

The Weekday() function returns the weekday of a Date/Time value. By default, the result ranges from 1 (Sunday) to 7 (Saturday).

Syntax

Weekday(ThisItem.DateColumn, StartOfWeek.[Weekday])

• ThisItem.DateColumn: The column contains valid dates or date-time values you want to evaluate.

• StartOfWeek.[Weekday] (optional): Specifies which day of the week to treat as the first day.

By default, Sunday is the first day (1 = Sunday, 7 = Saturday), and you can specify it:

StartOfWeek enumeration	Description
StartOfWeek.Sunday	Numbers 1 (Sunday) through 7 (Saturday). Default.
StartOfWeek.Monday	Numbers 1 (Monday) through 7 (Sunday).
StartOfWeek.MondayZero	Numbers 0 (Monday) through 6 (Sunday).
StartOfWeek.Tuesday	Numbers 1 (Tuesday) through 7 (Monday).
StartOfWeek.Wednesday	Numbers 1 (Wednesday) through 7 (Tuesday).
StartOfWeek.Thursday	Numbers 1 (Thursday) through 7 (Wednesday).
StartOfWeek.Friday	Numbers 1 (Friday) through 7 (Thursday).
StartOfWeek.Saturday	Numbers 1 (Saturday) through 7 (Friday).

You can use this syntax to define the weekday of the current day

Weekday(Today(), StartOfWeek.[Weekday]

Examples

If you have a date field ThisItem.DueDate in a table and you want to find out what day of the week it falls on:

Weekday(ThisItem.DueDate, StartOfWeek.Monday)

If ThisItem.DueDate is September 18, 2024 (a Wednesday), this formula would return 3 since Monday is treated as a day 1.