The WORKDAY ( ) Function

Adding days to or subtracting days from a date is straightforward, but the basic calculation includes all days: workdays, weekends, and holidays, rn many cases, you might need to ignore weekends and holJdays and return a date that is specified number of workdays from some original date.

You can do this by using the Analysis ToolPak's WORKDAY ( ) function, which returns a date

that is a specified number of working days from some starting dates.

Syntax:
WORKDAY( startdate, days[, holidays])
Start Date:
The original date (or a string representation of the date)
Days:
The number of workdays before or after start date. Use a positive number to return a later date; use a negative number to return an earlier date. Non-integer values are truncated (that is, the decimal part is ignored)

Holidays:

A list of dates to exclude from the calculation. This can be range of dates or an array constant (that is, a series of date serial numbers or date strings, separated by commas and surrounded by braces{ })

Example 1:
The following expression returns a date is 30 workdays from today: =WORKDAY(TODAY(),30)

Example2:

Note
here's another expression that returns the date that is 30 workdays from December 1, 2011, excluding December 25, 2011, and January 1,2012: =WORKDAY("11/2/2011",30,{"25/12/2011","1/1/2012"})

If you don't find this function in the list, lead the Analysis ToolPak add-in.