Excel (2007) "workday" how to add days to a date and include saturday, for a schedule.

[drg7001]

Hello All,

I am new to Excel, and working on a project timeline.

I am trying to insert a number of days in column "b" for the amount of time each job will take.

In column "c" I have the start date, and in column "d" i have the end date.

I would like it to work so that when I enter the days to complete and the Start Date entered, it will automatically calculate the End Date (using working days) and include Saturdays. I do not need holidays included.

For example: B7: Duration: 22 days
C7: Start date: 2/15/2016
D7: End Date: 3/10/2016 - (I have tried numerous different macros with no success, I usually come up with 3/08/2016 or 3/16/2016).


The problem with most macros are that they used "networkdays" and needed a start and end date, I do not want to use a start and end date however, I need the macro to be placed in the end date column, so that when I change my duration, it automatically calculates the end date.

I have also tried using workday2 from here Better Workday but it would not work for me.

Thank you for your time.

 

[Jonmo1]

Make sure the references are correct.
Date in C7, duration (22) in B7

Excel 2010
	B	C	D	E
7	22	2/15/2016		3/10/2016
Sheet1

Cell Formulas
Range	Formula
E7	=CountSaturday(C7,B7)

 

[drg7001]

All of that is right, except we are doing nothing with E7

D7 is where we are entering =CountSaturday(C7,B7)

 

[drg7001]

Is there anyway for me to post my timeline so that you can see it?

 

[Jonmo1]

Can you post it to a filesharing site like box.com or something?

Or see my signature for a link to a tool that can post nice snapshots of your tables.

 

[drg7001]

I now have Excel 2010, I am going to try your original macro

 

[drg7001]

Spot on!

The original line you posted worked perfectly now that I am upgraded to 2010!

=WORKDAY.INTL(C7-1,B7,11)

I really appreciate all the help, Thank you!