Converts a serial number of a day in the week in Excel
Converts a serial number to a day of the week


Converts a serial number of a day in the week


The Excel WEEKDAY function returns an integer between 1 and 7 the corresponds specific day of a week. Example; to find dayth (07-04-2018: Cell-B6) number of a week starting from Monday, use =WEEKDAY(B6,2) that returns ‘6’.




serial_number – A valid argument of date, string representation or a serial number of a specific date.
return_type [optional] – Setting custom start day of a week.

Return Value

Return value is an integer between 1 and 7.

Key Notes

  • In simple term, WEEKDAY function helps you figure out which day of the week a date falls on.
  • Use VLOOKUP function to return days alphabetically.
  • The WEEKDAY function throws an integer even if the referring cell in the formula is blank.
  • Problems can occur if dates are entered as text or manually in the parenthesis as an argument.
  • It is preferred to change the format as general for the resulting cell.

Following table shows Return_type [optional] arguments for the WEEKDAY function:

Return_typeNumber returned
1 or omittedNumbers 1 (Sunday) through 7 (Saturday).
2Numbers 1 (Monday) through 7 (Sunday).
3Numbers 0 (Monday) through 6 (Sunday).
11Numbers 1 (Monday) through 7 (Sunday).
12Numbers 1 (Tuesday) through 7 (Monday).
13Numbers 1 (Wednesday) through 7 (Tuesday).
14Numbers 1 (Thursday) through 7 (Wednesday).
15Numbers 1 (Friday) through 7 (Thursday).
16Numbers 1 (Saturday) through 7 (Friday).
17Numbers 1 (Sunday) through 7 (Saturday).

Keep Reading Similar Functions:

Get the week number of a date in Excel


The WEEKNUM function finds the week number of date and week start day, i.e., week starting from Monday (05-06-2018-C7), use =WEEKNUM(B7,2) that returns ‘23’.

Read More »
Find the difference between two dates in Excel


The DAYS function returns the difference between two dates. To find days duration between two dates, use DAYS(“01/08/2018″,”01/05/2017”) that returns ‘457’.

Read More »
Find the ISO week number of a year for a given date in Excel


The ISOWEEKNUM function return ISO week number considering a week begins on Monday. Example; date (09-03-2017), use = ISOWEEKNUM(date) that returns 10.

Read More »