How to Add Days to Date Excluding Weekends and Holidays in Excel

This post will guide you how to add days to a given date excluding weekends and holidays with a formula in Excel.

Add Days to Date Excluding Weekends and Holidays


Assuming that you have a list of data in range B1:B4, which contain date values. And you want to add days to a given date excluding weekdays and all the specified holidays in Excel. How to do it. You can use a formula based on the WORKDAY function to achieve it. Like this:

=WORKDAY(B2,D2,C2:C3)

Cell D2 contain the number of days to be added to the date. C2:C3 is the list of holiday dates.

add days to date excluding weekday and holiday1

Type this formula into a blank cell and press Enter key. And go to HOME tab, select Short Date from the Number Format drop down list under Number group.

add days to date excluding weekday and holiday2

 

And then drag the AutoFill handle over to other cells to apply this formula.

add days to date excluding weekday and holiday3

If you only want to add days to date excluding weekdays, you can use the following formula based on WORKDAY function. Like this:

=WORKDAY(B2,D2)

add days to date excluding weekday and holiday4

Related Functions


  • Excel WORKDAY Function
    The Excel WORKDAY function returns a serial number that represents a date that is the indicated number of working days before or after the starting date you specified. The syntax of the WORKDAY function is as below:=WORKDAY(start_date, days, [holidays])…

You might also like:

Comments

So empty here ... leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

Sidebar