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.

Weekday formula
STEP 2: The WEEKDAY arguments:

Date

What is the date?

Select the date you have entered

=WEEKDAY(B13,

Weekday formula

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)

Weekday formula

Now we know the day in an instant!

Weekday formula

 

How to Use the Weekday Formula in Excel

 

HELPFUL RESOURCE:

How to Combine VLOOKUP and IFERROR to Replace the #N/A Error in Excel

 

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

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

WEEKDAY function: Introduction | MyExcelOnline