Excel Date Functions : WEEKDAY

Introduction to WEEKDAY Function

WEEKDAY function returns a day number (ranging from 0 to 7) of the week from a date. In simple words, the WEEKDAY function takes a date and returns the day number of that date’s day. This is another useful DATE Function in Excel.

Download Sample File

Download Sample Files to work, practice and master the Date Functions in Excel.

Syntax of WEEKDAY Function

WEEKDAY (serial_number, [return_type])

Arguments of WEEKDAY Function

• serial_number: A valid date from which you want to get the week number.
• [return_type]: A number that represents the day of the week to start the week.

Example of WEEKDAY Function in MS Excel

In the below example, we have used a WEEKDAY with TODAY to get a dynamic weekday. It will give you the weekday whenever the current date changes. You can use this method in your dashboards to trigger some values which need to change when weekday change.

In the below example, we have used WEEKDAY with IF to create a formula that first checks the weekday of date and return “Weekday” or “Weekend” basis on the value return from WEEKDAY.

Other Excel Date Functions Tutorials

You can explore and master other date functions in Microsoft Excel. Here is a complete list of date functions available in Microsoft Excel.

• DATE Function
• DATEVALUE Function
• DAY Function
• DAYS Function
• EDATE Function
• EOMONTH Function
• MONTH Function
• NETWORKDAYS Function
• NETWORKDAYS.INTL Function
• TODAY Function
• WEEKDAY Function
• WEEKNUM Function
• YEAR Function