In this tutorial, you will learn how to get the day of the week from a date in Excel and how to count the number of weekdays/working days between two dates.
DAY function
- Function DAY (WEEKDAY) in Excel returns a number between 1 (Sunday) and 7 (Saturday) representing the number of the day of the week. It appears that December 16, 2013 in the formula below falls on a Monday.
=WEEKDAY(A1)=ДЕНЬНЕД(A1) - You can also use the function to display the day of the week TEXT (TEXT).
=TEXT(A1,"dddd")=ТЕКСТ(A1;"дддд")
- Create a custom date format (dddd) to display the name of the day of the week.
Function CLEAR
- Function PURE WORKERS (NETWORKDAYS) returns the number of weekdays (excluding weekends) between two dates.
=NETWORKDAYS(A1,B1)=ЧИСТРАБДНИ(A1;B1) - If you specify a list of holidays, then the function PURE WORKERS (NETWORKDAYS) will return the number of working days (excluding weekends and holidays) between two dates.
=NETWORKDAYS(A1,B1,E1:E2)=ЧИСТРАБДНИ(A1;B1;E1:E2)The calendar below will help you better understand the function PURE WORKERS (NETWORKDAYS).
- Excel stores dates as numbers and counts the number of days since January 0, 1900. Instead of substituting a range of cells into the formula, substitute the number constants that represent those dates. To do this, select E1: E2 in the formula below and click F9.
=NETWORKDAYS(A1,B1,{41633;41634})=ЧИСТРАБДНИ(A1;B1;{41633;41634})
WORKDAY function
- Function WORKDAY (WORKDAY) almost opposite functions PURE WORKERS (NETWORKDAYS). It returns the date before or after the specified number of weekdays (weekends excluded).
=WORKDAY(A1,B1)=РАБДЕНЬ(A1;B1)
Note: Function WORKDAY (WORKDAY) returns the serial number of the date. Apply a date format to a cell to display it.
The calendar below will help you better understand the function WORKDAY (WORKDAY).
Again, if you substitute a list of holidays, the function WORKDAY (WORKDAY) will return the date before or after the specified number of working days (excluding weekends and holidays).