Return to List of Excel Functions

WEEKDAY Function – Day of Week From Date in Excel & G Sheets

Download Example Workbook

Download the example workbook

This tutorial demonstrates how to use the WEEKDAY Function in Excel and Google Sheets to get the day of the week (1-7).

Weekday Function in Excel


WEEKDAY Function Overview

The WEEKDAY Function Returns the day of the week as a number (1-7).

To use the WEEKDAY Excel Worksheet Function, Select cell and Type:

weekday formula syntax

(Notice how the formula input appear)

WEEKDAY Function syntax and Inputs:


serial_number – The date in Excel serial number format or entered as a date with quotations (“s) surround the date. Example: You can not enter 11/12/2015 directly into the cell. Instead you need to enter “11/12/2015” or you would need to use the corresponding serial number: 42320. Alternatively, you can reference a cell with the date 11/12/2015 entered. Excel automatically converts dates stored in cells into serial format (unless the date is entered as text).

return_type – OPTIONAL. A number


Calculate Day of Week From a Date

The WEEKDAY Function Returns the day of the week as a number (1-7).

Weekday Without a Return Type in Excel

By adding the CHOOSE Function you can return the name of the day of the week:



Change Start of Week

By default, weeks start on Sundays, instead you change the start of the week to any day. Here we use 2 to change to week start to Monday instead of Sunday (the default):


WEEK Start on Monday

Here are more examples of changing the start of the week:


WEEKDAY Function

WEEKDAY in Google Sheets

The WEEKDAY Function works exactly the same in Google Sheets as in Excel:

WEEKDAY Google sheet

Easy Excel Automation

Add Excel automation to your workbook with just a few clicks.

Learn More

WEEKDAY Examples in VBA

You can also use the WEEKDAY function in VBA. Type:


For the function arguments (serial_number, etc.), you can either enter them directly into the function, or define variables to use instead.

Excel Practice Worksheet

practice excel worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to List of Excel Functions