In a formula column, the DAY_IN_WEEK() function displays the number of the day in the week of a date column.

Formula

DAY_IN_WEEK(Colonne1)

Example

DAY_IN_WEEK(Date)

Configurator

Result

May 8, 2021 is a Friday, the 5th day of the week: function returns 5.

May 19, 2021 is a Tuesday, the 2nd day of the week: function returns 2.

17 May 2021 is a Sunday, for Sunday the function returns 0.