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
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.
Or continue with
Formula glossary
All available operators and functions, sorted by category.