To add or subtract working days to a date to calculate a date in the future or past that skips weekends and holidays you can use WORKDAY function in Excel. WORKDAY function allows you to add or subtract working days to a date. By default WORKDAY function exclude Saturdays and Sundays, you can also exclude holidays (Federal or State) by supplying a range of cells that contain holiday dates.

To download the example excel file used in this video please click on the link below
[ Ссылка ]

свернуть