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 ...
Read More:How to Add Days to A Date in Excel Excluding Weekends How to Add Months (e.g. 6 Months) to Date in Excel Steps: Enter the formula below in cellD5. =DATE(YEAR(B5),MONTH(B5)+C5,DAY(B5)) CellB5indicates the cell of theDatescolumn and cellC5refers to the number ofMonths...
When you start a project that needs 35 business days to complete, you may want to know which date is the end date. In Excel, the WORKDAY function or the WORKDAY.INTL function can help you. WORKDAY function: add business days to a date excluding Saturday and Sunday and holidays....
working days resulting in the date of the 10th working day. 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...
Method 6 – Using the WORKDAY.INTL Function to Exclude Customized Weekends & Holidays Steps: InC5, enter: =WORKDAY.INTL(B5,30,7,$E$5:$E$9) PressEnter andautofill the entire column to see the output. Read More:How to Add Days to a Date in Excel Excluding Weekends ...
WORKDAY.INTL函数 通用公式: WORKDAY.INTL(start_date,days,[weekend],[holidays]) 参数 Star_date: the start date that used to calculate the end date. Days: the number of business days that you want to add. Weekend: A number or a serial number determines which days of week are considered ...
Add or subtract days to date with formula You may have noticed that dates are 5-digit numbers in Excel. Therefore, you can add or subtract days as easy as adding or minus the number of days in Excel. = date + number of days 1. Select a blank cell you will place the calculati...
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. ...
Below is the formula that would give you the date after adding the given number of working days: =WORKDAY(B2,C2) WORKDAY function in Excel takes three arguments: The date to which you want to add a specific number of workdays (B2 in our example) The total number of workdays that you...
In case you want to add more weeks (say 3), you can use the below formula: =A2+7*3 In the above formula, I multiplied the number of weeks by 7 to give me the total number of days in those weeks and then added those days to the given date. Note: Since we have used a formula...