选择一个空白单元格并输入以下公式,然后按“Enter”键获取结果。 =WORKDAY(A2,B2,B4:B6) Copy 提示:在公式中,A2是开始日期,B2是要添加的天数,而B4:B6是需要排除的节假日。 使用Kutools for Excel添加包括周末和节假日的天数 如果你想添加包括周末和节假日的天数,可以使用“Kutools for Excel”的“日期和时间助...
WORKDAY excludes weekends (Saturday and Sunday).1. The WORKDAY function below returns the date 1/1/2026.Explanation: the WORKDAY function does not include the start date. The calendar below helps you understand this formula. There are 11 circles....
In our example, use this formula to add days and excluding weekends: =WORKDAY(B2,C2) Exclude the holidays You can also skip holidays. In the example below, holiday dates are in column G. Use the WORKDAY function like this to include these dates: Arabic week The WORKDAY function considers...
1. In this function, the weekends are defined as Saturday and Sunday. If you want to use different weekend, you can try the WORKDAY.INTL function. 2. If the argument days is a decimal value, the WORKDAY function only add the integer number to the start_date. ...
1. 在 A2 單元格輸入起始日期,然後在 A3 單元格輸入此公式:=WORKDAY(A2,1,$D$2:$D$6),然後按下Enter鍵,將會顯示一個五位數字,如下方截圖所示: 備註:在上述公式中,A2是您輸入第一個日期的單元格,D2:D6是包含您要排除的假日的區域。 2. 然後向下拖動填滿控制點到您想插入序列日期的單元格,如下方截圖...
With the WORKDAY function, in recons the weekends are Saturday and Sunday, if you have your own custom weekend, you can use theWORKDAY.INTLfunction. Supposing the weekends are Monday and Tuesday, please use the formula as: =WORKDAY.INTL(B3-1,1,3,$E$3:$E$7)=B3 ...
The Microsoft Excel WORKDAY function adds a specified number of work days to a date and returns the result as a serial date. Weekends are not considered work days and you can specify holidays to also exclude from the work day calculation. The WORKDAY function is a built-in function in Exc...
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 holidays. Use WORKDAY to exclude weekends or holidays when you calc
Get midpoint of two dates excluding weekends and holidays Generic formula WORKDAY(start_date,(end_date-start_date)/2,holidays) Syntaxt and arguments Start_date, End_date: the two dates that used to get the midpoint. Holidays: the days that you want to exclude when counting. ...
Method 3 – How to Calculate the Last Workday in a Month in Excel Use the WORKDAY function. Select a cell and enter the formula: =WORKDAY(EOMONTH(C5,0)+1,-1, $F$5:$F$8) Use the Fill Handle to autofill the other cells. The formula returns the last workdays including the holiday...