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

Weekday

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

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin