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
- YEAR - The function returns the year corresponding to a date in Excel
year: the function returns the year value corresponding to a date in excel. the year value returns an integer with a value between 1900 and 9999. syntax: year (serial_number). - YEARFRAC function - The function returns the fifth calculated by the number of whole days between two specific dates in Excelyearfrac function: the function returns the fifth calculated by the number of whole days between two specific dates in excel. syntax: yearfrac (start_date, end_date, [basis])
- 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])
- DATEDIF function - The function calculates the number of days, months, years between 2 dates in Exceldatedif function: the function performs the calculation of number of days, months, years between 2 dates in excel. functions are useful in formulas for calculating age numbers. syntax: datedif (start_date, end_date, unit)
- DATEVALUE function - Functions to convert text format dates to serial numbers in Exceldatevalue function: the function converts the stored date value as text into a serial number recognized by excel. the function is useful in cases where the worksheet contains the date format you want to filter or sort. syntax: datevalue (date_text)
- DAY function - The function returns the date value of a specific date in Excelthe day function: the function returns a date value in a specific date, month, and year format in excel. syntax: day (serial_number)
Office information
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
- DATE function - The date function in Excel
- WEEKDAY function - The function returns the weekday of a corresponding date in Excel
- COUPNCD - The function returns the next coupon date 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
DATE function - The date function in Excel
WEEKDAY function - The function returns the weekday of a corresponding date in Excel
COUPNCD - The function returns the next coupon date in Excel