Excel WEEKDAY Function

HomeExcel FunctionsExcel WEEKDAY Function (Example + Sample File)


The Excel WEEKDAY Function is listed under Microsoft Excel's Date Functions category. It 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.

How to use it

To learn how to use the WEEKDAY function in Excel, you need to understand its syntax and arguments:


WEEKDAY (serial_number, [return_type])


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


  • If you skip specifying return type it will take 1 as default.
  • You can also use a date that is in textual form, a result of another function, or you can enter a date directly into the function by using double quotation marks.


To master the WEEKDAY function we need to try it out in an example, so make sure to check out the below one:

In the below example, we have used a WEEKDAY with TODAY to get a dynamic weekday.

It will give you the weekday whenever 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 weekday of date and return “Weekday” or “Weekend” basis on the value return from WEEKDAY.

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.