Add business days to date

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. Both formulas show the result of adding 5 workdays, starting from December 23, 2024. The first formula excludes weekends only returns December 30, 2024. The second formula excludes weekends and holidays and returns January 2, 2025. Notes: This is a basic example based on a standard 5-day workweek. If you need to customize which days are workdays and non-work days, see this page. (2) The dates in columns D and E are not required in this solution, they exist only to help visualize how the WORKDAY function evaluates working and non-working days and arrives at a final result. See below for details on how this is set up.

April 14, 2025 · 1 min · 166 words · Michael Clark

The dates in columns D and E are dynamically generated based on the start date in B5.

Conditional formatting is used to shade excluded days in gray and to highlight the final calculated dates in yellow.

All calculations are performed with the WORKDAY function.

The worksheet uses four conditional formatting rules

WORKDAY can optionally exclude holidays as well as weekends.

The names are for convenience only and make the formulas easier to read.

The result is Thursday, January 2, 2025.

The worksheet uses four conditional formatting rules

Notice the holidays in the range B11:B13 are valid dates.

The dates are dynamically generated based on the start date withSEQUENCE function.

This works becauseExcel datesare stored as serial numbers.

The worksheet uses four conditional formatting rules

“Mon”) followed by the date.

The formula returns TRUE and the shading is applied.

The result is that more days are shaded since both weekends and holidays are non-working days.

The worksheet uses four conditional formatting rules

In column E, the second formula checks for a date equal to the result in cell G6.

The difference is that the conditional formatting is unlinked from column G results and therefore self-contained.

The worksheet uses four conditional formatting rules

Excel formula: Add workdays to date custom workweek

Excel formula: Add days exclude certain days of week

Excel formula: Date is workday

Excel formula: Get project end date

Excel WORKDAY function

Excel WORKDAY.INTL function