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

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

Calculate Day of Week from a Date

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

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

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)

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

=WEEKDAY(B3,D3)

WEEKDAY in Google Sheets

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

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.