How to get an end date for a schedule excluding Sundays?

[Taner]

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

 

[Eduardo]

Hi,
Look into CPearson web

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

 

[Taner]

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.

 

[Chip Pearson]

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

 

[Taner]

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

 

[Taner]

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