Search results
To add or subtract business days (workdays) to a date, you can use a formula based on the WORKDAY function. In the example, the formulas in G5 and G6 are: =WORKDAY(start,days) =WORKDAY(start,days,holidays) Where start (B5), days (B8), and holidays (B11:B13) are named ranges.
Add or subtract any number of days to/from a date, taking into account public holidays in your country and weekends.
22 mar 2024 · The WORKDAY function of Excel is designed to calculate the workday after or before a certain number of business days from a given date. For example, you tell Excel to give you the workday that falls 30 days after 31 November 2024, and it will calculate it for you.
You can add or subtract a number of days to or from a date by using a simple formula, or you can use worksheet functions that are designed to work specifically with dates in Excel.
Formula. =WORKDAY(start_date,days,holidays) Explanation. In the example, the formula in D6 is: =WORKDAY(B6,C6,B9:B11) This adds 7 days to Tuesday, Dec 22 and returns Tuesday, January 5, 2016. How this formula works. By default, the WORKDAY function will exclude weekends (Saturday and Sunday).
18 mar 2023 · The NETWORKDAY function is tailor-made for calculating business days or working days. The function assumes a Saturday-and-Sunday weekend by default and returns the working days between two dates by excluding Saturdays and Sundays.
18 mar 2024 · Upgrade your Excel skills with our guide on date arithmetic! Learn to add and subtract dates, manage timelines & handle holidays like a pro.
