adding bussines days to a date

[wiredgecko]

this is what i am trying to accomplish:

say i have a field with the date 5/20/15(or any other date for that matter)...i want to add "x" number of business days(work days not weekends).

thxs

 

[Danerida]

If your date is in A1:

=WORKDAY(A1,X)

If you wish to exclude public holidays, make a list of the holiday dates and then add a reference to that list:

=WORKDAY(A1,X,HolidaysList)

Replace "X" with your required number.