WEEKDAY + IF (weekend check) Function in Excel: Syntax, Examples and Free Practice
WEEKDAY + IF (weekend check) is an Excel Date & Time function. Uses WEEKDAY to get a date's day-of-week number, then IF to classify it as a weekend or weekday.
WEEKDAY + IF (weekend check) syntax
Arguments
date_cell: The date to check
When to use WEEKDAY + IF (weekend check)
Flagging which scheduled deliveries fall on a weekend so they can be rescheduled.
Practice WEEKDAY + IF (weekend check) online, free
Open the live Excel-style spreadsheet and try WEEKDAY + IF (weekend check) yourself. No Excel install or sign-up needed to start.
Practice WEEKDAY + IF (weekend check) now →More Date & Time functions
Frequently asked questions
What does the WEEKDAY + IF (weekend check) function do in Excel?
Uses WEEKDAY to get a date's day-of-week number, then IF to classify it as a weekend or weekday.
What is the syntax of WEEKDAY + IF (weekend check) in Excel?
The syntax is =IF(WEEKDAY(date_cell,2)>5, "Weekend", "Weekday"). date_cell: The date to check.
Where can I practice WEEKDAY + IF (weekend check) online for free?
Open the free live spreadsheet on Cellgrids and try WEEKDAY + IF (weekend check) yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Date and Time functions · Excel case studies · Excel tutorials · Excel shortcuts