Workdays Including Start Date and Saturdays

[amoto]

Hello,

I was reading a previous thread on this but was having trouble with solution provided. I would like to set up a spreadsheet where I have a Start Date, Duration, and Finish Date. I want that when I put in a duration it will account for Saturdays and the actual date in which the activity starts.

For Example,
Start Date: 05/24/13
Duration: 3
Calculated Finish Date: 05/27

The above example is how I would like the table to perform. The calculated finish date accounted for the actual day the activity started as well as Saturday.
I’m not very good with VB functions and have no experience with array formulas so a detailed response would be greatly appreciated.
A formula is preferred.

Thanks in advance!

[Kevin UK]

Hi amoto

As you have Excel 2010, try the WORKDAY.INTL function.
Assuming the data is as follows.
A1: Date
A2: Number of days.
=WORKDAY.INTL(A1,3,"0000001")-1

[amoto]

That couldn't have been easier. Thank you for your help.