The WORKDAY function - The function returns a date before or after the start date of a number of working days in Excel
The following article introduces you to the WORKDAY 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 date of a specified number of working days. Weekends and public holidays do not count toward business days.
Syntax: WORKDAY (start_date, days, [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.
- 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 days after the working day a specified number of days for the following jobs:
- In the cell to calculate, enter the formula: = WORKDAY (F7, G7, H7).
- Press Enter -> return value is:
- Similarly copying the formula for the remaining value results:
- Where the number of holidays is greater than 1 enter the formula: = WORKDAY (F9, G9, H9: H10).
- Press Enter -> return value is:
Above are instructions and some specific examples when using the WORKDAY function .
Good luck!
You 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 function - The function returns the number of whole working days between 2 dates in Excel
- COUPNCD - The function returns the next coupon date in Excel
- The DAYS function - The function returns the number of days between 2 dates in Excel
- DAYS360 function - The function returns the number of days between 2 dates, based on 360 days in Excel
- WEEKDAY function - The function returns the weekday of a corresponding date in Excel
May be interested
- Coupdays function - Calculates the number of days in a coupon period and contains the settlement date in Excelthe following article details how to use the coupdays function in excel. function meaning: the coupdays function calculates the number of days in the coupon period and contains the settlement date. syntax: coupdays (settlement, maturity, frequency, [basis]).
- DATE function - The date function in Excelthe date () function returns a date that is formatted corresponding to the date entered as based on the date index.
- How to calculate the number of days in Excelhow many days from january 9, 2015 to june 12, 2017? if you can find results within 5 seconds, you are truly a genius. however, this is no longer a problem when you know how to use excel.
- WEEKDAY function - The function returns the weekday of a corresponding date in Excelweekday function: the function returns the weekday of a corresponding day. the return value is an integer between 1 (sunday) and 7 (saturday). syntax: weekday (serial_number, [return_type])
- COUPNCD - The function returns the next coupon date in Excelcurrently, stock investment is no stranger to people, the matter is concerned daily. therefore, the following article introduces the coupncd function in detail to help you calculate the next coupon date.
- YEAR - The function returns the year corresponding to a date in Excelyear: 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).
- Complete financial functions in Excel you should knowfv, date, time, hour, workday, ... functions are the basic financial functions with the same way of getting color codes in excel. show you how to use these financial functions. click view now!
- 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)
- TODAY function - The function returns the current date value in the format in Exceltoday function - the function returns the current date value in the format in excel. the today () function does not automatically update, but requires setting changes to control.
- COUPNUM function - The function returns the number of interest payments on a security in Excelin the process of investing in securities, paying special interest is very important. it helps you calculate and plan a reasonable calculation and investment. the following article details the coupnum function - the function returns the number of interest payments of securities in excel.