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

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on November 6, 2023
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

Calculate Day of Week from a Date

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

Weekday Without a Return Type in Excel

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

=CHOOSE(WEEKDAY(B3),"Sun","Mon","Tue","Wed","Thu","Fri","Sat")

WEEKDAY Choose

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):

=WEEKDAY(B3,2)

WEEK Start on Monday

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

=WEEKDAY(B3,D3)

WEEKDAY Function

WEEKDAY in Google Sheets

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

WEEKDAY Google sheet

WEEKDAY Examples in VBA

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

application.worksheetfunction.weekday(serial_number,return_type)

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

AI Formula Generator

Try for Free

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