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

Share on Google+

Google+

Related Posts

Excel´s EndOfMonth function   What does it do? Returns the last day of the month after a start date Formula breakdown: =EOM(start_date, months) What it means: =EOM(Your Start Date, enter 0 for current end of month, 1 for the next end of month, and so on...) The EOMONTH (EndO...
Advanced SUMPRODUCT Function: Maximum Sales What makes the SUMPRODUCT function even more powerful is its ability to nest formulas, or in simple terms, add another function within the SUMPRODUCT function. Instead of getting the Total Sales for a region, we can extract the Maximum sales value simply by entering the MAX fu...
Advanced SUMPRODUCT Function: Sum Multiple Criteri... What does it do? It returns the sum of multiple criteria from the corresponding ranges or arrays Formula breakdown: =SUMPRODUCT((array 1 criteria) * (array2 criteria) * array values) What it means: =SUMPRODUCT((find my criteria in this array) * (find my criteri...
GETPIVOTDATA Function What does it do? A formula that extracts data stored in a Pivot Table Formula breakdown: =GETPIVOTDATA(data_field, pivot_table, , ,...) What it means: =GETPIVOTDATA(return me this value from the Values Area, any cell within the Pivot Table, ,...)   T...