Calculate completion date from start date and duration - only work days

**Robsheep** · 03-22-2015, 05:26 AM

Hello,

I am drawing up a basic programme, with known start dates and duration. I am using the workday function and have created a nonworking day or holiday table to deduct the public holidays.

I would like to calculate the end date to be inclusive i.e start on Monday 23 March 2015, with a duration of 6 work days, I would like the answer to be Monday 30 March 2015, currently it indicates Tuesday 31 Mar 2015.

Thank you

**Glenn Kennedy** · 03-22-2015, 05:49 AM

Since youre more than half-way there, it'd be easier to complete if you were to attach your worksheet here.

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**tim201110** · 03-22-2015, 07:31 AM

like that_____________

**daddylonglegs** · 03-22-2015, 07:46 AM

Just subtract 1 from the start date within the formula and that will include that date (if it's a working day) e.g. for six working days starting with the date in A2 use this formula

=WORKDAY(A2-1,6,holidays)

where holidays is your holiday range

If A2 is 23/3/2015 the result will be 30/3/2015 assuming no intervening holidays

**Robsheep** · 03-22-2015, 08:48 AM

Thanks Glenn, please find Sample sheet attached

**Robsheep** · 03-22-2015, 10:41 PM

I cannot open the attachment, am I doing something wrong?

**Glenn Kennedy** · 03-23-2015, 03:31 AM

The attachment opens perfectly OK for me. I see that Daddylonglegs has already provided the solution for you. Hopefully that's your question answered.