View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Taner Taner is offline
external usenet poster
 
Posts: 4
Default How to get an end date for a schedule excluding Sundays?

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