Home
Tech info
Technology
Science
Life
Application
Electric
Program
Mobile
Windows 10
Windows 11The WORKDAY.INTL function - The function returns a date before or after the date starting with a custom weekend in Excel
The following article introduces you to the WORKDAY.INTL function - one of the functions in the date and time group function is very popular in Excel.
Description: The function returns a date before or after the start of a specified number of working days with a custom weekend. The weekend parameter indicates which day and how many days.
Syntax: WORKDAY (start_date, days, [weekend], [holidays])
Inside:
- start_date: The start date, is a required parameter.
- days: A day not in the weekend and holidays before or after start_date, is a required parameter.
+ days> 0 -> number of days generated in the future.
+ days <0 -> number of days created in the past.
- weekend: Indicates which days are weekends not included in the working day, are optional parameters with the following values:
+ weekend = 1 -> The weekend is Saturday and Sunday.
+ weekend = 2 -> The weekend is Sunday, Monday.
+ weekend = 3 -> Weekends are Monday and Tuesday.
+ weekend = 4 -> Weekends are Tuesday and Wednesday.
+ weekend = 5 -> Weekends are Wednesdays and Thursdays.
+ weekend = 6 -> Weekends are Thursday and Friday.
+ weekend = 7 -> Weekends are Friday and Saturday.
+ weekend = 11 -> Weekends are only Sunday.
+ weekend = 12 -> Weekends are only Monday.
+ weekend = 13 -> Weekends are only Tuesday.
+ weekend = 14 -> Weekends are only Wednesday.
+ weekend = 15 -> Weekends are only Thursday.
+ weekend = 16 -> Weekends are only Friday.
+ weekend = 17 -> Weekends only Saturday.
- holidays: Days to be excluded from working days which are not on public holidays.
Attention:
- Excel stores dates as sequential serial numbers to facilitate the calculation process.
- Any one of the arguments is invalid -> the function returns the #VALUE! Error value
- If start_date + days value creates an invalid date -> the function returns the #NUM! Error value
- If days is a decimal, it is truncated to an integer.
For example:
Calculate the day after the working day a certain number of days, weekends are defined by the values in the weekend column of the following jobs:
- In the cell to calculate, enter the formula: = WORKDAY.INTL (F7, G7, H7, I7).
- Press Enter -> return value is:
- Similarly copying the formula for the remaining value results:
Above are instructions and some specific examples when using the WORKDAY.INTL function in Excel.
Good luck!
Marvin FryYou should read it
- DATE function - The date function in Excel
- DAY function - The function returns the date value of a specific date in Excel
- NOW function - The function returns the current date and time in Excel
- NETWORKDAYS.INTL function - The function returns the number of whole working days between 2 dates, specifying weekends in Excel
- COUPNCD - The function returns the next coupon date in Excel
- WEEKDAY function - The function returns the weekday of a corresponding date in Excel
- TODAY function - The function returns the current date value in the format in Excel
- Excel date function - Usage and examples
May be interested
- Excel date function - Usage and examples
the date counting function in excel is one of the most effective functions of this software. because excel usually works in the field of statistics and calculations, it is extremely necessary to record dates. to help you understand this function, let's come to the following article of tipsmake. - How to use the NORMDIST function in Excel - Function that returns the distribution in Excelthe normdist function returns a distribution with a specified mean and standard deviation. the normdist function has applications in statistics, including hypothesis testing.
- CHISQ.TEST function - The function returns the independence test in Excelchisq.test function: the function returns the independence test. the function returns the value from the distribution (({chi ^ 2})) when squared for statistics and the appropriate degrees of freedom. support function from excel 2010 version. syntax: chisq.test (actual_range, expected_range)
- How to use the IF function in Excelthe if function in excel checks for a true or false condition. if the condition is true, the function returns a value, if the condition fails the function returns another value
- ISOWEEKNUM function - The function returns the ordinal number of the year of the week that contains the given date in Excelisoweeknum function: the function returns the ordinal number of the year of the week that contains the given date. syntax: isoweeknum (date)
- NETWORKDAYS.INTL function - The function returns the number of whole working days between 2 dates, specifying weekends in Excelnetworkdays.intl: the function returns the number of whole working days between two dates by using a parameter that determines the number of weekends and which day of the week. syntax: networkdays.intl (start_date, end_date, [weekend], [holidays])
- F.TEST function - The function returns the result of the F - test in Excelf.test: the function returns the result of the f - test, the probability of two ends where the variance of 2 arrays is not significant. support functions from excel 2010 version. syntax: f.test (array1, array2)
- GAMMA function - The function returns the gamma function value in Excelgamma: the function returns the gamma function. support functions from excel 2013 onwards. syntax: gamma (number)
- POISSON.DIST function - The function returns the Poisson distribution in Excelpoisson.dist function: the function returns the poisson distribution, the application function to predict the number of events in a specific time. support functions from excel 2013 onwards. syntax: poisson.dist (x, mean, cumulative)
- WEIBULL function - The function returns the Weibull distribution in Excelthe function performs the calculation and returns the weibull distribution. based on this distribution to analyze reliability in theory such as calculating the average life of the device or used in the field of meteorology, hydrology and weather forecast.
Office information
- YEAR - The function returns the year corresponding to a date in Excel
- YEARFRAC function - The function returns the fifth calculated by the number of whole days between two specific dates in Excel
- NETWORKDAYS.INTL function - The function returns the number of whole working days between 2 dates, specifying weekends in Excel
- DATEDIF function - The function calculates the number of days, months, years between 2 dates in Excel
- DATEVALUE function - Functions to convert text format dates to serial numbers in Excel
- DAY function - The function returns the date value of a specific date in Excel
YEAR - The function returns the year corresponding to a date in Excel
YEARFRAC function - The function returns the fifth calculated by the number of whole days between two specific dates in Excel
DATEDIF function - The function calculates the number of days, months, years between 2 dates in Excel
DATEVALUE function - Functions to convert text format dates to serial numbers in Excel
DAY function - The function returns the date value of a specific date in Excel