WORKDAY 函数用于在起始日期上添加指定的工作日天数,并以序列号格式返回未来或过去的日期。计算时会排除周末和您指定的假期。此函数通常用于在 Excel 中计算发货日期。 语法和参数 公式语法WORKDAY(开始日期,天数,[假期])参数开始日期:必需。用于计算工作日的起始日期。 天数:必需。希望添加到起始日期的指定工作日天数...
Function CalculateWorkdaysExcludingHolidays(startDate As Date, daysToAdd As Integer, holidays As Range) As Date Dim resultDate As Date Dim counter As Integer Dim holidayDate As Date resultDate = startDate counter = 0 Do While counter < daysToAdd resultDate = resultDate + 1 ' 默认每日递...
The WORKDAY function will exclude weekends, that is, Saturday and Sunday. If we need to customize which days of the week are considered weekend days, use the more robust WORKDAY.INTL function. How to use the WORKDAY Function in Excel? The WORKDAY function was introduced in Excel 2007 and...
This article describes the formula syntax and usage of the WORKDAY function in Microsoft Excel. Description Returns a number that represents a date that is the indicated number of working days before or after a date (the starting date). Working days exclude weekends and any dates identified as...
This article describes the formula syntax and how to use the WORKDAY.INTL function in Microsoft Excel. This function returns the serial number of the date before or after a specified number of workdays with custom weekend parameters. Optional Weekend parameters can indicate which and how many ...
How to Use the Workday Formula in Excel If you want to get the day of the week based on the date,click your to learn about the WEEKDAY function. If you like this Excel tip, please share it Bryan Bryan Hong is an IT Software Developer for more than 10 years and has the following ...
This article describes the formula syntax and usage of the WORKDAY function in Microsoft Excel. Description Returns a number that represents a date that is the indicated number of working days before or after a date (the starting date). Working days exclude weekends and any dates identified as...
ExcelDaysFunction To calculate the number of days between two given dates, the DAYS function in Excel can help you. ExcelDAYS360Function DAYS360 function can help you to return the number of days between two dates based on a 360-day year, which is considered to have 30 days in each month...
FunctionDescriptionSyntax WORKDAY Returns date after specified workdays =WORKDAY(start_date, days, [holidays]) NETWORKDAYS Counts workdays between dates =NETWORKDAYS(start_date, end_date, [holidays])This table shows the core differences between the two functions. WORKDAY moves forward/backward in ...
The WORKDAY.INTL function (new in Excel 2010) returns a date serial number that is the specified number of working days before or after the start date.