Calculate Finish Date by adding start date with duration and Exclude weekends

HTML Code: 

in B3, copied down.

Format B3 as short date.

coolcruiser,

I could not make up if you needed a new day before or after the weekend.
You could use this code to add 1 or 2 days ( depending on saturday or sunday) to set the date to next Monday.

Please Login or Register  to view this content.

You can alter the code if you need the date to be on a friday before the weekend (saturday or sunday)

Please Login or Register  to view this content.

i enclosed you workbook and added 2 worksheets with code adding or substracting a day after or before the weekend.

MarMo,
Looking at your solution, Row 16 has 6/13/2018 as finish date on both sheets.

OP needs to clarify if this should be 6/15/2018. Does he want to count weekend days in the "Days Required" or should we skip all weekend days?
If we want to skip all weekend days, then my simple formula [see msg # 2] takes care of that.

modytrane,

point taken.
There was no indication on what was really needed, so i presumed that weekends could be counted as well.
If we only want workingdays counted, then your formula works better!

To mark your thread solved do the following:
New Method
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved