DAY_IN_WEEK() : extract the day-of-week number

Used in a formula column, the DAY_IN_WEEK() function extracts the day-of-week number from a date-type column. It is used to identify weekends, schedule tasks based on the day, or trigger different rules depending on whether it is a weekday or the weekend.

Numbering starts at 0, not 1. Sunday = 0, Monday = 1, Tuesday = 2, Wednesday = 3, Thursday = 4, Friday = 5, Saturday = 6.

Syntax

DAY_IN_WEEK(date_column)

Parameters

# Parameter Description

1 date_column The date-type column for which you want to know the day of the week.

Examples

Find the day of the week

For a Wednesday, the formula returns 3. For a Sunday, it returns 0.

DAY_IN_WEEK($Date)

Tip: combine DAY_IN_WEEK() with TERNARY CONDITION() to display a readable label (for example “weekend” if the result is 0 or 6, “weekday” otherwise) instead of the raw number.

Go further

DAY()

Extract the day of the month instead of the day of the week.

Read more →

Or continue with

Formula glossary

All available operators and functions, sorted by category.