Auto Populate a date only including work days

Hi all,

i am wanting to create a formula or if there is any easier way to auto populate a date in a field.

what i want to do is

cell 1 ........................ ........... cell 2 ......................................... cell 3
(inputted date)....................... (inputted number of days) ............. inputted date + inputted number of days (not including weekends and bank holidays if possible)

so what would show is

Cell 1................cell 2.......................................Cell 3
31.08.2016..............6 ................................. 08.09.2016

any help would be greatly appreciated.
thank you in advance

There is a function for that.

=WORKDAY(A1,B1)

To exclude bank holidays, you would need to make a list of them and add that to the optional holidays argument of the function. (The excel help file contains an example).

Here:

Formula:

Please Login or Register  to view this content.

If you create holiday list you can also use it:

Formula:

Please Login or Register  to view this content.

Where in Sheet2!$A$1:$A$1000 you have holidays and other days you want to exclude.

That's Great Thank you