I am making a schedule using Excel. I have the start date and the number of
days the employees will be working. I want to get the end date, but exclude
Sundays only. The employees work 6 days a week.

For example: Start Date: 4/1/2010
Number of working days: 7
The End Date would be: 4/8/2010

If I use WORKDAY it bases it off of Mon-Fri.
Not sure exactly the best way to go about this. Any help is greatly
appreciated!

Thanks

Hi,
Look into CPearson web

http://www.cpearson.com/excel/betternetworkdays.aspx

"Taner" wrote:

I am making a schedule using Excel. I have the start date and the number of
days the employees will be working. I want to get the end date, but exclude
Sundays only. The employees work 6 days a week.

For example: Start Date: 4/1/2010
Number of working days: 7
The End Date would be: 4/8/2010

If I use WORKDAY it bases it off of Mon-Fri.
Not sure exactly the best way to go about this. Any help is greatly
appreciated!

Thanks

Hi,

I don't need to figure the workdays. I need to figure the end date from my
start date and number of days they will be working.

"Eduardo" wrote:

Hi,
Look into CPearson web

http://www.cpearson.com/excel/betternetworkdays.aspx

"Taner" wrote:

I am making a schedule using Excel. I have the start date and the number of
days the employees will be working. I want to get the end date, but exclude
Sundays only. The employees work 6 days a week.

For example: Start Date: 4/1/2010
Number of working days: 7
The End Date would be: 4/8/2010

If I use WORKDAY it bases it off of Mon-Fri.
Not sure exactly the best way to go about this. Any help is greatly
appreciated!

Thanks

You can use my Better Workday VBA function, available at
http://www.cpearson.com/excel/BetterWorkday.aspx . It allows you to
specify any one or more days of the week to exclude from the
calculation. It is the corollary to my Better NetWorkdays function.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional,
Excel, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com




On Thu, 8 Apr 2010 10:35:01 -0700, Taner
wrote:

Hi,

I don't need to figure the workdays. I need to figure the end date from my
start date and number of days they will be working.

"Eduardo" wrote:

Hi,
Look into CPearson web

http://www.cpearson.com/excel/betternetworkdays.aspx

"Taner" wrote:

I am making a schedule using Excel. I have the start date and the number of
days the employees will be working. I want to get the end date, but exclude
Sundays only. The employees work 6 days a week.

For example: Start Date: 4/1/2010
Number of working days: 7
The End Date would be: 4/8/2010

If I use WORKDAY it bases it off of Mon-Fri.
Not sure exactly the best way to go about this. Any help is greatly
appreciated!

Thanks

Ok I see how that works, but how do I get that to work in my work book? It
seems to work on your better workday workbook, but I don't know how to get
all of that function into my workbook.

Thanks



"Chip Pearson" wrote:

You can use my Better Workday VBA function, available at
http://www.cpearson.com/excel/BetterWorkday.aspx . It allows you to
specify any one or more days of the week to exclude from the
calculation. It is the corollary to my Better NetWorkdays function.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional,
Excel, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com




On Thu, 8 Apr 2010 10:35:01 -0700, Taner
wrote:

Hi,

I don't need to figure the workdays. I need to figure the end date from my
start date and number of days they will be working.

"Eduardo" wrote:

Hi,
Look into CPearson web

http://www.cpearson.com/excel/betternetworkdays.aspx

"Taner" wrote:

I am making a schedule using Excel. I have the start date and the number of
days the employees will be working. I want to get the end date, but exclude
Sundays only. The employees work 6 days a week.

For example: Start Date: 4/1/2010
Number of working days: 7
The End Date would be: 4/8/2010

If I use WORKDAY it bases it off of Mon-Fri.
Not sure exactly the best way to go about this. Any help is greatly
appreciated!

Thanks
.

Nevermind. I figured it out. Thanks for the help!

"Taner" wrote:

Ok I see how that works, but how do I get that to work in my work book? It
seems to work on your better workday workbook, but I don't know how to get
all of that function into my workbook.

Thanks



"Chip Pearson" wrote:

You can use my Better Workday VBA function, available at
http://www.cpearson.com/excel/BetterWorkday.aspx . It allows you to
specify any one or more days of the week to exclude from the
calculation. It is the corollary to my Better NetWorkdays function.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional,
Excel, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com




On Thu, 8 Apr 2010 10:35:01 -0700, Taner
wrote:

Hi,

I don't need to figure the workdays. I need to figure the end date from my
start date and number of days they will be working.

"Eduardo" wrote:

Hi,
Look into CPearson web

http://www.cpearson.com/excel/betternetworkdays.aspx

"Taner" wrote:

I am making a schedule using Excel. I have the start date and the number of
days the employees will be working. I want to get the end date, but exclude
Sundays only. The employees work 6 days a week.

For example: Start Date: 4/1/2010
Number of working days: 7
The End Date would be: 4/8/2010

If I use WORKDAY it bases it off of Mon-Fri.
Not sure exactly the best way to go about this. Any help is greatly
appreciated!

Thanks
.