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
- galuega tauave ASO (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
- galuega tauave GALUEGA MAMA (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 GALUEGA MAMA (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 GALUEGA MAMA (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
- galuega tauave ASO GALUEGA (WORKDAY) almost opposite functions GALUEGA MAMA (NETWORKDAYS). It returns the date before or after the specified number of weekdays (weekends excluded).
=WORKDAY(A1,B1)
=РАБДЕНЬ(A1;B1)
Manatua: galuega tauave ASO GALUEGA (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 ASO GALUEGA (WORKDAY).
Again, if you substitute a list of holidays, the function ASO GALUEGA (WORKDAY) will return the date before or after the specified number of working days (excluding weekends and holidays).