What does it do?

Returns the day of the week corresponding to a date.  The day is given as an integer, ranging from 1 (Sunday) to 7 (Saturday), by default.

Formula breakdown:

=WEEKDAY(Serial_Number, [Return_Type])

What it means:

=WEEKDAY(Date, [Numbers 1 (Sunday) through 7 (Saturday)])


The WEEKDAY function returns the day of the week corresponding to a date.  The day is given as an integer, ranging from 1 (Sunday) to 7 (Saturday).

So if you want to find out on what day you were born, then the WEEKDAY function will remind you.

WEEKDAY function: Introduction | MyExcelOnline

DOWNLOAD EXCEL WORKBOOK

STEP 1: Enter any date that you want.

VLOOKUP Function: Introduction
STEP 2: The WEEKDAY arguments:

Date

What is the date?

Select the date you have entered

=WEEKDAY(B13,

VLOOKUP Function: Introduction

Return_Type

What kind of output?

Type in 1 to get the number of the day of the week

See also  10 + 1 Ways to Round Numbers in Excel

We get a result of 7 here, which signifies a Saturday. As Type 1 represents days ranging from 1 (Sunday) to 7 (Saturday).

=WEEKDAY(B13, 1)

VLOOKUP Function: Introduction

Now we know the day in an instant!

VLOOKUP Function: Introduction

 

How to Use the Weekday Formula in Excel

 

 

HELPFUL RESOURCES:

JOIN OUR FREE EXCEL COURSES BELOW
Click here to access these FREE Excel courses!

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin