Pinterest Pixel

WEEKDAY function: Introduction

What does it do? Returns the day of the week corresponding to a date.  The day is... read more

Download Excel Workbook
John Michaloudis
Posted on

Steps To Follow

Overview

WEEKDAY function: Introduction | MyExcelOnline WEEKDAY function: Introduction | MyExcelOnline

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.

Download excel workbookWeekday.xlsx

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

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!

See also  INDIRECT Function in Excel

VLOOKUP Function: Introduction

 

 

 

If you like this Excel tip, please share it
WEEKDAY function: Introduction | MyExcelOnline WEEKDAY function: Introduction | MyExcelOnline
Founder & Chief Inspirational Officer at MyExcelOnline.com

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship Academy Online Course.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...