在本文中,我们将探讨如何在 Excel 中将工作日添加到日期(不包括周末和节假日)。此方法可确保在添加天数时仅计算工作日(周一至周五),非常适合项目调度或计算依赖于工作日的截止日期等任务。 使用公式添加工作日(周末除外) 使用公式添加工作日(周末和节假日除外) 使用Kutools for Excel 添加包括周末和节假日在内的日期...
Tip: In the formula, A2 is the start date, B2 is the days you want to add, and B4:B6 is the holidays you want to exclude.Add days including weekends and holidays with Kutools for Excel If you want to add days including weekends and holidays, you can use Kutools for Excel...
Number of days to add:Enter how many days to add. The function automatically skips weekends. [Optional] Holidays:Add any dates to exclude, like July 4th or Christmas Day. In our example, use this formula to add days and excluding weekends: =WORKDAY(B2,C2) Exclude the holidays You can a...
Read More: How to Add 30 Days to a Date in Excel Case 2.2 – Excluding a One-Day Weekend Suppose the weekend is only on Friday. The weekend parameter to be used is 16. The formula will be: =WORKDAY.INTL(C7, D7, 16) Case 2.3 – Excluding Non-Consecutive Weekends A string of sev...
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 to add. Holidays: a list of dates that you want to exclude when calculating. ...
To add days to a date while excluding specific days (i.e. exclude Tuesdays and Thursdays, Wednesdays only, etc.) you can use the WORKDAY.INTL function with a special pattern code see the example below: Formula =WORKDAY.INTL(date,days,"pattern") ...
5 Simple Methods to Add Days to Date Using Excel Formula Method 1 – Adding 2 Cells to Add Days to Date in Excel Steps: Enter the following formula in cell D5. =B5+C5 Cell B5 represents the cells of the Dates column and cell C5 refers to the cells of the Days (+/-) column. Pr...
1.选择要放置结果的单元格,单击Kutools>Formula Helper>Date & Time helper. 2.在Date & Time Helper在对话框中,选择所需的一个计算选项,然后选择用于计算的日期,然后键入要加或减的年,月,日的数量。 3。 点击Ok,日期已添加或减去。 最佳办公生产力工具...
Example 1. Adding days to a date in Excel The general formula to add a specified number of days to a date in as follows: Date+N days The date can be entered in several ways: As a cell reference, e.g.=A2 + 10 Using the DATE(year, month, day) function, e.g.=DATE(2015, 5,...
1 - Displays the current date. Custom format "dddd dd mmmm yyyy". 2 - Displays the current date and time. Custom format "dddd dd mmmm yyyy hh:mm:ss". 3 - Displays the date that is 7 business days after the date in cell "A1". ...