=WORKDAY(start_date,days,[holidays]) Bash Copy 其中, Start_date− 开始计算工作/工作日的日期。 Days− 在初始倒计时完成后,应添加到起始日期的工作日数。 Holidays− 可选地从工作日计算中排除的日期列表。这可以是指示日期的序列号的数组常量或包含您想要从计算中省略的日期的单元格范围。 ...
要添加除周末之外的其他日子,您可以执行以下操作: 选择一个空白单元格并键入此公式= WORKDAY(A2,B2),然后按输入获得结果的关键。 提示:在公式中,A2是开始日期,B2是要添加的日期。 现在显示的是结束日期,其中增加了 45 个工作日(周末除外)。 请注意:如果计算结果是5位数字,则可以通过以下方式将其设置为日期格式...
If you're using Excel to calculate dates, it is useful to know how to add (or subtract) a certain number of working or business days to a date. This lesson introduces the WORKDAY() function and shows you how to use it. Scenario You have a project spreadsheet in which you have a ...
WORKDAT.INTL函数:添加到目前为止的工作日,但不包括某些天(自定义周末)和节假日。 工作日功能 通用公式: WORKDAY(start_date,days,[holidays]) 参数 Star_date: the start date that used to calculate the end date. Days: the number of business days that you want to add. ...
=WORKDAY(C5,D5) CellC5refers to the cell of theDeadlinescolumn and cellD5indicates the cell of theWeekendscolumn. PressENTER. You will have the following output in cellE5. Use theAutoFilloption to obtain the remaining outputs. Read More:How to Add Days to A Date in Excel Excluding Weeken...
WORKDAT.INTL function: add business days to date excluding certain days (custom weekend) and holidays. WORKDAY FunctionGeneric formula:WORKDAY(start_date, days, [holidays]) ArgumentsStar_date: the start date that used to calculate the end date. Days: the number of business days that you want...
InOperation, selectAdd. PressEnter. The new dates will be displayed inColumn B. Method 4 – Adding 30 Days to the Current Date Using the TODAY Function Steps: InC5, enter: =TODAY()+30 PressEnterto see the output. Method 5- Using the WORKDAY Function to Exclude Weekends & Customized Ho...
Register To Reply 05-16-2006, 02:35 PM #2 Mark Lincoln Guest Re: Can Excel add working days to a date to result in another date? Use the WORKDAY function. These examples are from the Excel 97 help entry for WORKDAY: WORKDAY(DATEVALUE("01/03/91"), 5...
= date + number of days 1. Select a blank cell you will place the calculating result, type the formula =A2+10, and press the Enter key. Note: For subtracting 10 days from the date, please use this formula =A2–10.2. If you need to apply this formula to other cells, please...
Step 1: The first thing you need to do is enter a cell's function. Additionally, you can use the function in a formula too. Suppose you want to add days to 7 dates (a week) in cell A1; then, here’s how to create a date formula. ...